Subject | TIBOQuery to TClientDataSet really slow |
---|---|
Author | Tim Knipe |
Post date | 2003-09-16T03:12:34Z |
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
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