asked on August 1, 2023
Hi, what would you suggest to improve the performance during the rendering of the FlexMonster pivot table?
We have 37 fields, 250K rows, which is 66Mb of data. The analyzing phase takes ~15s.
It is improvable at all?
We compare this performance to the performance of AG Grid which takes nearly 3-4s with the same dataset.
⋅ August 2, 2023
Hello, Volodymyr!
Thank you for reaching out to us.
We understand your concern about the performance. To provide more accurate recommendations, we kindly ask for additional details about the described use case of Flexmonster:
If possible, we would greatly appreciate it if you could provide us with the code snippet you are using for testing the performance.
Looking forward to hearing from you.
Best Regards,
Maksym
⋅ August 2, 2023
> Which data source type you were using?
JSON
> Were you loading the data from the local file system, passing the inline JSON data, or loading it from the remote source?
Passing the inline JSON data
> Which view type was used during the test (pivot or flat)?
Pivot
> Were you using the same configurations while testing the data analyzing speed of AG Grid?
The same
Performance testing is done approximately (by an eye), cause we are not talking about 1-2sec of difference, the difference is 15sec vs 3-4, thus we do not need any script while the difference is so big 🙂
⋅ August 3, 2023
Hello, Volodymyr!
Thank you for sharing this information with us.
For optimizing the data analysis speed, we recommend using Flexmonster Data Server — a special server-side tool developed by Flexmonster. 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. Delegating the data analyzing process to the server would significantly improve the performance of Flexmonster with big datasets.
You can find the detailed instruction on how to connect Flexmonster to a JSON file in our guide: https://www.flexmonster.com/doc/pivot-table-connect-to-json/
Please let us know if using FDS could be a feasible solution for you.
Best Regards,
Maksym
