This is a migrated thread and some comments may be shown as answers.

Large amount of data with PivotGrid

1 Answer 155 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Ruben
Top achievements
Rank 1
Ruben asked on 11 Jan 2013, 02:58 PM
Hi Telerik. 

In our company we're looking forward to using the asp.net ajax controls. I've been doing some spikes with them and we are very interested in the PivotGrid particularly. It is a great control, very useful and easy to implement. Nevertheless, when the grid needs to handle large amount of data, let's say for example 25000 records, the rendering kills the browser. Do you figure out a posible solution for this problem? Something like the virtual scrolling functionality of the GridControl.

Thanks and good work.

1 Answer, 1 is accepted

Sort by
0
MasterChiefMasterChef
Top achievements
Rank 2
answered on 15 Jan 2013, 03:59 PM
Hi Ruben,

the RadPivotGrid is a great control for viewing large amounts of data, but with 25,000 records any control would slow down the browser and / or break. Are you trying to display all 25,000 records at once? It might help if you enabled paging so only a specified amount will be displayed at once. Also, are you editing these records in the PivotGrid? If not, it might benefit you to set EnableViewState to 'False'. 

There is a Webinar on tv.telerik.com that is about optimizing a RadGrid control. The video is over an hour long, but it has some great tips on optimizing the speed that your Grid is loaded into your browser. The demos start at about 20 minutes in. Hopefully this information helps you optimize your RadPivotGrid.

Good luck,
Bart
Tags
PivotGrid
Asked by
Ruben
Top achievements
Rank 1
Answers by
MasterChiefMasterChef
Top achievements
Rank 2
Share this question
or