ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Learn how to use FireDAC's TFDQuery FetchOptions to implement on-demand pagination, reducing memory overhead and preventing application crashes when handling large datasets in RAD Studio.
Goal: Page through a large dataset using TFDQuery Limit and Offset while avoiding full-table downloads to the RAD Studio client. FireDAC translates Limit and Offset into native SQL when the connected server and driver support pagination. For older servers without native OFFSET or FETCH support, the library may instead retrieve all matching rows and apply the
radstudio