Hi.
As an separate additional query is required to obtain the total number of records in a table with server side limit offset based pagination, it'd be more natural to have both the data query and this 'total row count' query triggered when 'refresh' button is clicked or refresh() function is triggered