Editorial question81.9K views4,280 votes0 answers2,502 following
AI-generatedFireDAC 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