Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Is there any way to have pagination or lazy loading in api response?

Arpit Gupta asked on April 30, 2020

Hi team,
We are going to use flexmonster for reporting purpose but we want to know is there any way to handle pagination or lazy loading as data size might go beyond >1lakh rows.
Our source is a sql db.
Any clarification would be really appreciated.

3 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster April 30, 2020

Hi Arpit,
Thank you for writing to us.
Currently, pagination is not supported in Flexmonster. What we usually suggest in such cases is to consider the recently introduced Flexmonster Data Server. Flexmonster Data Server is a server-side utility implementing our custom data source API, which allows you to load large data sets to Flexmonster quickly & easily. The main advantage of this tool is that all the heavy lifting of fetching, processing and aggregating the data is carried out on the server-side, after which only the necessary data is passed to the pivot table. This ensures that the browser’s resources are used much more efficiently while the data itself is loaded much faster, eliminating the problem of loading 100,000+ rows into the pivot table.
Feel free to check out the following documentation page for more information on Flexmonster Data Server:
If, however, you need to display the data in flat view specifically, all the data has to be loaded at once regardless. Therefore, as a potential workaround, we would suggest using more precise database queries to narrow down the results only to the parts of the data that need to be displayed right now.
Please let us know if this helps.
Best regards,

Mykhailo Halaida Mykhailo Halaida Flexmonster May 7, 2020

Hi Arpit,
How are you?
We were wondering if our response helped you with your question. Was it helpful, or perhaps you still have any questions we can help you with?
Please let us know what you think.
Kind regards,

Mykhailo Halaida Mykhailo Halaida Flexmonster May 18, 2020

Hi Arpit,
Hope you’re doing well!
We are just checking in to ask if you’ve found our response helpful. Did it help you resolve the mentioned issue or do you still have some questions?
Looking forward to your response.

Please login or Register to Submit Answer