Subject TIBOQuery to TClientDataSet really slow
Author Tim Knipe
Using IBO4 on Delphi 7 with Interbase 5.6, I've got a TIBOQuery
connected to a TClientDataSet via a TDataSetProvider. For some reason
this takes over a minute (on a P4 2.4Ghz, 1GB RAM) to fill the
TClientDataSet, even if there is only 1 row in the TIBOQuery.

Using IBX in a similar way is instantaneous. However, I have to use IBO
for this project.

Has anyone seen this problem and is there anything I can do about it to
speed things up?

I tried various combinations of the following properties with no
improvement;
CachedUpdates
FetchWholeRows
KeyLinksAutoDefine
ReadOnly
Unidirectional


TIA
Tim Knipe