Fastest way to iterate through a large result set

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
tsteinmaurer
Posts: 52
Joined: Thu 17 Dec 2009 08:25

Fastest way to iterate through a large result set

Post by tsteinmaurer » Wed 03 Feb 2010 07:23

Hello,

what's the fastest way to iterate through a large result (> 1.000.000 records)? TIBCQuery with UniDirectional := True? Any other alternatives?

Thanks,
Thomas
Top
Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Thu 04 Feb 2010 12:17

Yes, this is the fastest way. In this case IBDAC holds the number of records specified in the FetchRows property only.
Top
Post Reply

Return to “InterBase Data Access Components”