AJAX RadPivotGrid very slow with large number of records in data source
Using RadPivotGrid with million and more records in data source, performance is very poor, and memory/CPU consumption/utilization goes very high.
Is there a way to optimize data loading in this control?
Posted on:08 Jun 2015 14:31
This portal is for general feedback or feature requests. In order of a particular questions regarding controls functionalities please use the support channels.
Posted on:15 Jan 2014 22:09
one more link:
Posted on:15 Jan 2014 22:07
I have noted memory problems with using the RadPivotGrid too with just 2000 rows of data and ~150 columns. I am guessing there is a memory leak, but maybe pivoting just eats up a lot of data even when the pivot is a valid one. I have noted documentation for the WPF version of the tool talking about getting better performance by using the QueryableDataProvider which I guess makes data stuff happen on server rather than application. I plan to try to use this in the near future. I believe that this may also help with the ASP.NET version. Also there is a page that talks about different ways to optimize the Grid tool and I am guessing some of that may apply as well. Here are some links: