Subject | Re: How to speed up reading TIBOQuery records |
---|---|
Author | Ed Dressel |
Post date | 2004-07-23T19:38:50Z |
> I can read about 30000 records in 20secs (HD is not still, althoughenough
> memory could be available) but often there are more needed and Iwould
> really like to speed up. Executing IBOQuery.Open over a large DB(600000
> records)A couple things that might help:
1) Call TIBQuery.DisableControls even if nothing is pointing at it.
(Haven't done this with IBO's but I have seen speed improvemnts with
all that I have).
2) And if you have TDataSource.Dataset pointing to the TIBOQuery, set
it's DataSet property to nil--this still increases speed.
Ed Dressel