Page 1 of 1

Re: Fastmethod to get to tge last records in a query.

Posted: Thu 25 Mar 2021 15:04
by oleg0k
Hello,
You may want to use the SmartFetch option
https://www.devart.com/ibdac/docs/devar ... tfetch.htm
when navigating through large recordsets. In this mode, only the records that are required at a specific moment will be fetched; the number of records to be fetched is determined by the FetchRows property. See this tutorial for other ways to increase performance: https://www.devart.com/ibdac/docs/incre ... rmance.htm

wbr, Oleg
Devart Team