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.
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: https://www.flexmonster.com/doc/getting-started-with-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.
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.
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.