Greetings for the day!!!
We are working on POC.
We are pulling the data from Snowflake DB an trying to create the dashboards. We have 1 million records data.
After loading the data into flexmonster, the browser automatically cache the data?
Is there a way that we can avoid flexmonster not to cache the data into browser? Can we handle/any configurable option in flexmonster?
Is there any user limits to access the reports?
Thank you for reaching out to us.
In case we understand correctly, the flat form is used in your case. Despite the connectivity type, the whole data set (1 million records) will be loaded to Flexmonster at once if the flat form is configured.
To render the received data and to operate with it, Flexmonster needs to store it on the user’s machine. It means the whole data set is preserved in the client’s RAM. We want to explain that the data set containing 1 million records is likely to exceed the limit imposed by most client’s machines.
We suggest prefiltering the data set on the backend to reduce the client-side load.
Concerning the caching, we want to explain the following. Flexmonster frees the memory allocated to the data set after another data set is loaded. It means the component does not store the data that is not needed at the moment.
As for accessing the reports.
Our team wants to explain that Flexmonster does not provide any technical limitations on loading reports.
If you need to impose some limitations (for example, security reasons), please provide us with the details so that we could find a suitable solution for your case.
We hope it helps.
Feel free to contact us in case further questions arise.