|Subject||Re: [IBO] Re: How to speed up reading TIBOQuery records|
> > I can read about 30000 records in 20secs (HD is not still, althoughThat didn't help. (If I won some miliseconds I didn't recognise :-)
> > memory could be available) but often there are more needed and I
> 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, setI don't.
> it's DataSet property to nil--this still increases speed.
What I did now is using Field[n] instead of FieldByName. But the surprising
thing is, that while reading 2000 records is faster, for 30000 its equal. I
think it's maybe that those 2000 recs fit in some cache whereas 30000 don't,
so then it is the HD which is the bottleneck of data throughput. Maybe I
don't really know.
Thanks for tips