To improve loading times, we have introduced a new configuration option within the Table widget, namely the Pagination for data source, which is applicable to the data source types of Query Template and External Data Source.
When enabled, this feature allows the loading of large datasets in smaller chunks using backend pagination. This improves performance and supports data sources with size limits.
In the Data source limit field, you can set a limit that is sent to the backend.
This differs from the Entries per page option in the Table Settings pane, which defines the frontend limit of actually displayed rows to the user.
In order for the backend pagination to function properly, you need to define several parameters in the query template or add placeholders in the external data source URL respectively.
In particular, these are the pageSize parameter, and either pageNumber or pageOffset.
For details, refer to Table widget.