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.
Thanks,
Arpit
⋅ 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: https://www.flexmonster.com/doc/getting-started-with-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
⋅ 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
⋅ 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.
Regards,
Mykhailo
⋅ February 8, 2021
Hi,
Just wanted to know as we can't go implement the suggested style. Will it be able to take more than 1 lakh records if we pass it in to flex pivot table.
Thanks,
Arpit
⋅ February 8, 2021
Hi Arpit,
Being a client-side component, Flexmonster relies on resources available to the browser, which affects the loading time and the maximum size of the data that can be handled on every particular machine. This means that the client machine’s RAM determines how much data can be loaded at once, and CPU capabilities affect how much time is spent on data processing.
Having said the above, 100,000+ rows of data are not a problem for Flexmonster, as long as the user’s computer is capable of processing them.
We hope this helps.
Best regards,
Mykhailo
⋅ March 26, 2021
Hi Mykhailo/Flexmonster Team,
I am using the Custom Datasource API and everything is working fine with the Pivot. But when it comes we do flat view(select-request-for-flat-table) form the Pivot, we are facing problem of loading data into the flat table.
Record size : 1,000,000(approx rows)
Flat table page size: 10,000
Request to server : 100
Problem:
Until all the pages are downloaded from the server flat view doesn't display anything on the UI.
We can't wait for that long(approx 30-60 min depending on network speed and how may fields need to display).
For Flat Table View in Custom API Datasource, we want lazy loading mechanism on scrolling the Flat View to download more data based on the Total page number.
I don't know about rest of the api. But for Flat View on Custom API Datasource It make sense to have lazy loading feature because all the computation we are doing on the database/server.
Regards,
Parmod Singh Rana
⋅ March 26, 2021
Hello, Parmod,
Thank you for contacting us.
It seems we have answered your question on our forum.
You are welcome to see our response on the following thread: https://www.flexmonster.com/question/custom-datasource-api-lazy-loading-of-flat-table-view/.
Kind regards,
Illia
