asked 1 day ago
Our data size is from 400 mega to 4 gigabytes, can this size be delivered from spring boot to browser with custom api?
⋅ 9 hours ago
Hello!
Thank you for reaching out to us.
As an entry point, let us explain how Flexmonster works with data when using our custom data source API.
Our custom data source API is a communication protocol that specifies in which format Flexmonster client can communicate with your server. In two words, the server would receive 4 types of requests from Flexmonster - /handshake, /fields, /members and /select.
When using a classic/compact pivot grid, the server sends only aggregated values to the browser, which reduces the browser load significantly. This way, you can control all the data processing and calculating on the server side and optimize it according to your requirements, and the client would only visualize the data you provided from the server.
From our experience, implementing custom data source API with your own server would be the best approach for the tech stack you described. You are welcome to start with checking out our introduction guide on the topic: https://www.flexmonster.com/doc/introduction-to-custom-data-source-api/.
For other performance improvements on such a large dataset, we suggest breaking down the dataset into smaller reports with pre-configured filters and slices instead of aggregating all the data into one large pivot.
Hope you will find our answer helpful.
Our team would be happy to assist you if you have any other questions about the custom data source API.
Kind regards,
Solomiia
