performance in pivotview over react

[CSI]

Hi, I am using the pivotview component. the data is consumed through a web service. a subset of data of 23400 records is used and the performance is good, displaying the data consumed in 14 seconds on the screen, but when the full set of 351000 records is used, it becomes very slow taking to display the data on the screen in more than 16 minutes, after this the navigation is very slow. the data used has approximately 40 columns. component virtualization is enabled (enableVirtualization = {true}) and services in the inject include VirtualScroll.

How  could be improve performance to display a large amount of data?

thanks,

ORLANDO RESTREPO 

[Sivamathi Natarajan]

Hi Orlando, 

 

Thanks for contacting Syncfusion support. 

 

We have planned to improve the performance of pivot table with huge data sets in web service after Volume 3 release which is scheduled on 1^st October, 2020. And we will update you the timeline as well after the release. Kindly track the tasks in the following links. 

 

https://www.syncfusion.com/feedback/18007/to-improve-the-performance-of-server-side-engine  

 

We appreciate your patience until then. 

 

Regards, 

Sivamathi. 

[Sivamathi Natarajan]

Hi Orlando, 

 

Thanks for contacting Syncfusion support. 

 

We have planned to improve the performance of pivot table with huge data sets in web service after Volume 3 release which is scheduled on 1^st October, 2020. And we will update you the timeline as well after the release. Kindly track the tasks in the following links. 

 

https://www.syncfusion.com/feedback/18007/to-improve-the-performance-of-server-side-engine  

 

We appreciate your patience until then. 

 

Regards, 

Sivamathi. 

[Sivamathi Natarajan]

Hi Orlando, 

 

The requirement will be available in our 2020, Volume 4 release which would be estimated to be rolled out by the end of December 2020. 

 

We appreciate your patience until then. 

 

Regards, 

Sivamathi. 

[CSI]

Hello, we have tried using a web service that generates a csv, and although it measures a third of the one generated in json when deployed in the component, it generates an out of memory in the browser.

regards,

ORLANDO RESTREPO BONILLA

[Sivamathi Natarajan]

Hi Orlando, 

 

We are validating the problem at our end. We will update the further details within two business days (10/13/2020). 

 

Regards, 

Sivamathi. 

[Sivamathi Natarajan]

Hi CSI,  

  

Thanks for contacting Syncfusion support.  

  

We have planned to improve the performance of server side pivot engine bind with huge data sets in our 2020 Vol 4 release, which is estimated to be rolled out by the end of December, 2020. Kindly track the tasks in the following link.  

  

https://www.syncfusion.com/feedback/18007/to-improve-the-performance-of-server-side-engine   

  

We appreciate your patience until then.  

  

Regards,  

Sivamathi.