Pagination in Easy Form Reports
This version adds a setting for controlling pagination in Easy Form Report macros: "Max rows for client-side pagination". The default value is 10,000 rows:
When the number of rows in the report is less than or equal to the number in this setting then client-side pagination is used in the report table. Else, server-side pagination is used.
Client-side pagination loads all rows of the report into memory in the browser (and on your server) and this makes sorting and search filtering fast. The tradeoff is that it uses more memory than server-side pagination and, when the number of pages is very large, it can bog down your server or your browser.
Server-side pagination loads only one page of data into memory in the browser (and on your server). It is a bit slower for sort/search but performs well for very large datasets (reports with many submissions).
You can tune this parameter for your report macro adjusting the number lower to give a preference to server-side pagination or higher to give a preference to client-side pagination. Set it to 0 to always use server-side pagination.
Server-side pagination has some limitations in sort/filter operations due to limitations imposed by SQL and the database schema for reports.
For sever-side pagination you cannot sort by submission value at the same time you are searching by submission value. For that case, you must sort by another field, like updated date, and then search by submission value.
Cannot sort multi-valued submission fields (checkboxes)
Cannot sort or search by user
Sort and search are case-sensitive