Hello
The problem we are facing is a GQI query which is sending back 2000 rows at least and first call seems to make a full load and then pagination is made on the dataset. So it takes a lot of time.
i would like to handle pagination on server side by myself but problem is that pagination properties available in payload of GetNextQuerySessionPage request are not available in the GetNextPageInputArgs argument of GetNextPage GQI function.
May be i am using the wrong class to get that ?
the answer which would say we should filter first to have less data is not accepted 🙂
thanks
Hi Julien,
It is currently not possible to know the pagesize in the GQI ad hoc data source. But in fact, that's not necessarely needed to improve the performance. Because within your ad hoc datasource you can define yourself how big the pages are that you want to return.
For example, you can create a GQIPage object with 10 rows and indicate that there are more rows by setting the HasNextPage boolean to true. If that boolean is true, GQI will know that there is more data. Which it will request if needed.
You can find an example here: https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/API_Reference/IGQIDataSource.html#examples
Hope this helps!
Best regards, Ward
I see that this question has been inactive for some time. Do you still need help with this? If not, could you select the answer (using the ✓ icon) to indicate that the question is resolved?