FireDAC and DBMS Interoperability: Server-Side Pagination Consistency
Pagination via FetchOptions In Delphi 10.4 and later, TFDQuery provides FetchOptions.RecordCount and FetchOptions.RecordsSkip to implement server-side bounding. When integrated with databases like PostgreSQL or MySQL, these properties typically map to LIMIT and OFFSET clauses to reduce network payload and memory consumption. DBMS Compatibility Constraints A
delphi