ADT

[MIGUELON]

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 ??

[rdonnay]

ADT tables are supported by the ADSDBE.

This is the simplest method.

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

[MIGUELON]

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

[rdonnay]

... 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.

[MIGUELON]

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.

[Eugene Lutsenko]

... 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?