Large amount of data with PivotGrid

2 posts, 0 answers
  1. Ruben
    Ruben avatar
    1 posts
    Member since:
    Jan 2013

    Posted 11 Jan 2013 Link to this post

    Hi Telerik. 

    In our company we're looking forward to using the 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.
  2. MasterChiefMasterChef
    MasterChiefMasterChef avatar
    152 posts
    Member since:
    Jan 2013

    Posted 15 Jan 2013 Link to this post

    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 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,
Back to Top