Large Dataset

I have 2 - 3 million rows of data when I pass them to the pivot table it gets choked. is there any way to handle large data sets of this size?


1 Reply

AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team September 30, 2022 11:22 AM UTC

Hi Zain,


We have virtualization and data compression option to avoid performance problems while binding large amount of data in the pivot table. For more information about the virtualization and data compression features, please refer the UG document below.


Virtualization: https://ej2.syncfusion.com/angular/documentation/pivotview/virtual-scrolling/#virtual-scrolling

Data Compressionhttps://ej2.syncfusion.com/angular/documentation/pivotview/virtual-scrolling/#data-compression


Meanwhile we have prepared a sample with 2million data for your reference:

Sample: https://stackblitz.com/edit/angular-dishwh?file=app.component.ts


Also, we having paging support to render pivot table with large amount of data. Please refer the below samples.


Online Demo: https://ej2.syncfusion.com/angular/demos/#/bootstrap5/pivot-table/paging

Sample: https://stackblitz.com/edit/angular-yyvnqm-bbna11?file=app.component.ts,app.component.html


Please let us know if you have any concerns.


Regards,

Angelin Faith Sheeba


Loader.
Up arrow icon