PivotView performance improvements

[Gerd Tautenhahn]

Hello,

we use the Angular PivotView and load the data from a relational database.

When having more than 10.000 rows in the datasource it is nearly impossible to add a calculated field because the RAM is fully occupied and it takes several minutes to add this field and to reload the pivot view.

I already added virtual scrolling, data compression and deferred layout update to improve the general performance.

Are there any settings to improve the overall performance?

And what should we do to improve the performance concerning calculated fields? We have some customers with multiple calculated fields which cannot wait multiple minutes for the pivot view to load.

[Sivamathi Natarajan]

Hi Gerd Tautenhahn, 

 

Thanks for contacting Syncfusion support. 

 

Please refer the below blog which shows you the options to improve the performance of the pivot table. 

 

https://www.syncfusion.com/blogs/post/tips-and-tricks-to-quickly-render-the-pivot-table.aspx 

 

Please let us know if you have concern. 

 

Regards, 

Sivamathi. 

[Gerd Tautenhahn]

Hello Sivamathi,

I followed the link and added all tips that are described in this blog article (most of them I had already) but the pivot table is still very slow. Can you maybe have a look at the pivot table component in your development team if there are any improvements possible? Especially the calculated fields are not very useful if you can't use them with more than 5000 rows before having a terrible perfomance.

Best regards

Gerd Tautenhahn

[Sivamathi Natarajan]

Hi Gerd, 

 

Kindly share us the fields count in each rows of the data source. So that we will check the same at our end and provide you the solution. 

 

Regards, 

Sivamathi. 

[Gerd Tautenhahn]

Hello Sivamathi,

we have two test cases:

• One pivot table with 4000 data sets and 4 calculated fields. It takes 14 seconds to load the view and 8 seconds to expand one row.
• One pivot table with 20000 data sets and 1 calculated field. I takes 40 seconds to load the view and 35 seconds to expand one row.

The virtual scrolling is already set.

[Sivamathi Natarajan]

Hi Gerd, 

 

We are validating the reported problem – “performance issue in virtual scrolling” at our end. We will update the further details within two business days (7/1/2020). 

 

Regards, 

Sivamathi. 

[Sivamathi Natarajan]

Hi Gerd, 

 

Sorry for the delay. 

 

We have prepared a sample with the mentioned raw dataset. But we are unable to reproduce the problem. Could you please ensure the reported problem in the provided sample? 

 

Sample with 4000 data set: https://stackblitz.com/edit/angular-3sqhep-nihnv5?file=app.component.ts 

 

Sample with 20000 data set: https://stackblitz.com/edit/angular-3sqhep-7ga2xj?file=app.component.ts 

 

If still the problem exists, kindly reproduce the problem in the provided sample and revert us (or) send your sample that replicating the problem. This would be a very helpful for us to investigate the reported problem at our end and provide the solution at earliest. 

 

Please let us know if you concern. 

 

Regards, 

Sivamathi.