Datamanager table listing: get total record count + records in single query

Description

When fetching records for the datatable in datamanager, we fire off two queries:

1. To fetch the total number of records
2. To fetch the paginated recordset

The performance of this could be improved by using using Count Over Window Function to fetch the total rows as a column in the single query to get the paginated recordset. This will especially improve performance for large tables and when complex filters are applied.

Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Unassigned

Reporter

Dominic Watson

Accepted

Yes