We are using a large amount of json data(about 400MB) as a pivot table. It’s about one million rows.
It takes about 1 minute and 40 seconds to display data.
you have to reduce this time.
which method would be the solution?
Thank you for reaching out to us.
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.
In order to handle larger data sets, we suggest using Flexmonster Data Server. The Data Server is a special server-side tool 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. The Data Server significantly reduces the time of data loading and enables analyzing large datasets.
Our team would like to provide some additional explanation about the difference between using Flexmonster Data Server and a direct connection to the JSON data source.
The main advantage of the Data Server is the fact that only the data needed to be displayed is loaded to the component. In its turn, a direct connection to the JSON data source requires preloading the whole data set and processing it on the client-side.
We suggest referring to our documentation dedicated to the Data Server. You will find detailed information about the tool and the step-by-step guide on installation and using Flexmonster Data Server.
We hope it helps.
Do not hesitate to contact us if any further assistance is required.
Are there any additional charges for using dataserver? Please tell me about the billing policy
Thank you for contacting us.
Our team would like to kindly explain that no extra charges are required in order to use Flexmonster Data Server. Using the Data Server is covered with Flexmonster license.
You are welcome to download an appropriate version of Flexmonster Data Server from our site.
Please refer to the earlier provided documentation in order to learn about ways to configure and use the Data Server.
Please let us know if any other questions appear.
Our team is wondering whether you had some time to test the Data Server.
Do not hesitate to contact us in case any assistance is needed.
We are looking forward to hearing from you.
We are interested in whether you had time to test Flexmonster Data Server.
Please let us know in case any questions on this point arise.
Our team is looking forward to hearing your feedback.