Random fast access to data
Posted: 09.05.2016, 17:57
Hi,
I have TZQuery that has 50000 records and I want to get record 10000 to 11000 in a loop BUT I dont want to set RecNo because it is slow for fast access.
As an example for fast speed if I make TDataLink and get make it's BufferCount to Query.RecordCount I can access much more faster than previous way with TDataLink.ActiveRecord.
I think it is because of that setting TZQuery.RecNo will trigger events and check many things that I dont want to check and I just want to access data as fast as I can.
Is there any ablity for such thing or hack to do this without making a huge buffer for TDataLink?
I have TZQuery that has 50000 records and I want to get record 10000 to 11000 in a loop BUT I dont want to set RecNo because it is slow for fast access.
As an example for fast speed if I make TDataLink and get make it's BufferCount to Query.RecordCount I can access much more faster than previous way with TDataLink.ActiveRecord.
I think it is because of that setting TZQuery.RecNo will trigger events and check many things that I dont want to check and I just want to access data as fast as I can.
Is there any ablity for such thing or hack to do this without making a huge buffer for TDataLink?