The performance of the pivot table component is good even we bound huge records when virtual scrolling feature is enabled. And it achieves the performance once when we bound the data source locally. But in remote data source, taking much time to fetch the huge size of records from server. Then only it can be bound to the component.
So, need to avoid such kind of delays. And, we have planned to achieve it in following ways,
- Introduce CSV data source type to reduce the data size over the connection.
- Compress the huge data in server end then pass the compressed data.
- Aggregation performs in server end then only the aggregated data to be passed in client end to render the component.