bb.donnay-software.com

Hi everyone and happy new year.
I am using Xbase++ 1.9, Express and Advantage as a BD engine with free DBF tables
I have a table with more than 2 million records and I would like to switch to free ADT tables.
Here is the question, what do you advise me:
1) Alaska ADSDBE
2) Directly with advantage commands for example AdsOpenTable
3) With Express SQL

Any advice ??

ADT tables are supported by the ADSDBE.

This is the simplest method.

SQL doesn't care if the data source is DBF or ADT.

Time Roger I think I have read that ADSDBE is not very stable with ADT tables but if you recommend it I will use it.
Thanks for the reply

... ADSDBE is not very stable with ADT tables...

There was a time when Steffen Pirsig did not recommend using ADT tables, but that was many years ago.

I worked with a customer on a manufacturing application that used both DBF and ADT tables, via ADSDBE, and I don't recall any problems with the ADT tables, however we were also using Xbase++ 2.0.

I have written a lot of code that utilizes the Ads* functions in the Ace Client engine, but I still think it was much easier and just as reliable to use the ADSDBE.

I recommend that you use a data dictionary rather than opening ADT files as free tables.

Why do you believe that the DBF format will not handle the 2 million records?

I have been working on an application, for years, that has supported a DBF file greater than 10gb in size, approximately 7 million records, on average.

Hi Roger, thanks for the reply.
I always thought that the limit of DBF tables was 4 GB, although it is true that there is no record limit.
I didn't know you could get this big.
I haven't gone to version 2.0 of Xbase++ even though I bought it because 1.9 works very well for me.
Following your recommendations, I continue for now with the DBF tables but joining them in a DB.

Thanks for your recommendations.

rdonnay wrote: ↑Thu Jan 05, 2023 1:53 pm

... ADSDBE is not very stable with ADT tables...

...
I have been working on an application, for years, that has supported a DBF file greater than 10gb in size, approximately 7 million records, on average.

How can I do this?