Board index » delphi » ClientDataSet question
2004-11-27 03:34:16 AM
I'm developing a muiti-database application that supports ADO and IBX, and
I'm using like this:
(TADOQuery or TIBQuery) -->TProvider -->TClientDataSet
I connect the TProvider to TADOQuery or TIBQuery depending on a parameter,
where it is specified what database I will use (Interbase or SQLServer).
The problem is when I am selecting a large amount of records, 50000 and over,
for instance, it takes almost 2 minuts to open. Why it takes so long? Is
this the better way for building muiti-database applications? If it is not,
what would be?
Thanks for any help.