Solved
Retrieving total count and paginating large datasets with Compose SDK
I'm currently working on implementing a custom table to handle a large dataset in Sisense, and I'm encountering some performance challenges related to pagination. Here's the scenario I'm facing: Req...
Hi herajapakse
Thanks for the detailed post and clear explanation of what you're trying to achieve.
Unfortunately, as David mentioned, getting the total row count of a query while only requesting a limited amount of rows is not currently supported. We have investigated the situation and are waiting on an enhancement from the backend API which would enable us to request the total number of rows.
Previously it has been suggested you could execute a separate query to count the number of rows instead of the aggregation you want in the paginated results, but it may not be a reliable solution for all cases.
For now you can implement paged queries with count and offset, just without the total row count at this time.
Steve
