Fastmethod to get to tge last records in a query.

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

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

Post by oleg0k » Thu 25 Mar 2021 15:04

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

Post Reply