FreeDAC is very fast and flexible at data rows fetching. 9 parameters control all aspects of row set fetching.

FreeDAC uses fast row array fetching technique to effectively fetch large row sets by RowsetSize rows at single fetch. You can also limit a maximum number of rows to be fetched (RecsMax). In FreeDAC you have a complete control under what and when will be fetched. "Manual", "On demand" and "All records" fetching modes are accessible (Mode). Also you can postpone BLOB’s and Nested Dataset fetching until they values will be really required to client (Items).

And FreeDAC automatically chooses appropriate DBMS cursor kind according to current fetch mode.