Last Updated: 08 Jun 2015 14:31 by ADMIN
Created on: 08 Nov 2013 21:51
Category: PivotGrid
Type: Feature Request
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?
(Total attached files size should be smaller than 20mb. Allowed extensions: .zip, .rar, .jpg, .png, .gif)
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: