Declined
Last Updated: 08 Jun 2015 14:31 by ADMIN
Bojan
Created on: 08 Nov 2013 21:51
Category: PivotGrid
Type: Feature Request
4
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)
3 comments
ADMIN
Radoslav
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.
robert
Posted on: 15 Jan 2014 22:09
one more link:

http://www.telerik.com/help/wpf/radpivotgrid-data-queryable.html
robert
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:

http://www.telerik.com/help/wpf/radpivotgrid-features-queryable-overview.html
http://demos.telerik.com/aspnet-ajax/grid/examples/performance/linq/defaultcs.aspx
http://www.telerik.com/help/aspnet-ajax/p_telerik_web_ui_radpivotgrid_usequeryabledataprovider.html