I have a CSV hosted on S3 bucket which contains around 500k of data, it takes around 20 sec to 1 min to first download the data and then to render, is there any way this can be optimized to improve user experience?
Hello,
Thank you for reaching out to us.
Could you please provide us with details on which approach you use to connect the data to Flexmonster?
Flexmonster provides data sources that do not require getting the whole dataset on the initial page load.
If you want to work with a large data set, we recommend using Flexmonster Data Server - a special server-side tool implementing the custom data source API. It is responsible for fetching data from a data source, processing, and aggregating it. Then, the data is passed to Flexmonster Pivot in a ready-to-show format. For instance, the Data Server will only pass the data that is needed for the specific expanded column. It significantly reduces data loading time.
The detailed guide you can find in our documentation: https://www.flexmonster.com/doc/getting-started-with-data-server/
Alternatively, you can implement the Flexmonster custom data source API – our custom communication protocol that allows you to transfer already aggregated data from a server to Flexmonster Pivot. Like Flexmonster Data Server, data is passed to Pivot in a ready-to-show format.
We recommend checking our guide on choosing the best data source for your use case: https://www.flexmonster.com/blog/how-to-choose-the-best-data-source-to-use-with-flexmonster/
Please let us know if further questions arise.
Kind regards,
Nadia