ADT

This forum is for eXpress++ general support.
Post Reply
Message
Author
MIGUELON
Posts: 135
Joined: Wed Feb 10, 2010 10:55 am

ADT

#1 Post by 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 ??

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: ADT

#2 Post by 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.
The eXpress train is coming - and it has more cars.

MIGUELON
Posts: 135
Joined: Wed Feb 10, 2010 10:55 am

Re: ADT

#3 Post by 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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: ADT

#4 Post by 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.
The eXpress train is coming - and it has more cars.

MIGUELON
Posts: 135
Joined: Wed Feb 10, 2010 10:55 am

Re: ADT

#5 Post by 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.

User avatar
Eugene Lutsenko
Posts: 1649
Joined: Sat Feb 04, 2012 2:23 am
Location: Russia, Southern federal district, city of Krasnodar
Contact:

Re: ADT

#6 Post by Eugene Lutsenko »

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?

Post Reply