Performance improvement in PivotGrid

2 posts, 0 answers
  1. Sabaridass
    Sabaridass avatar
    1 posts
    Member since:
    Dec 2015

    Posted 15 Dec 2015 Link to this post

    Hi There,

     We need to use more than 1,00,000 records for pivot grid in my project. Is there any possible to improve the performance of pivot grid rather than normal mode. If possible please suggest me the way or share me any ug reference link.


    Kind Regards,

    Sabari R

  2. Nasko
    Nasko avatar
    699 posts

    Posted 04 Jan 2016 Link to this post

    Hi Sabari,

    The performance of RadPivotGrid depends on the provider you are currently using.

    If your data is a local one and you are currently using the LocalDataSourceProvider all data will be loaded in the memory - the provider provides access to local source and if that source contains a lot of data the performance could not be improved as it depends on the memory of your machine.

    If you are using a database for your data we suggest you to use the QueryableDataProvider - thus your data should be loaded faster.

    The final approach that we could suggest you is to use OLAP Cube to store your data inside it and using AdomdDataProvider to get that data for RadPivotGrid - the data should also be loaded much faster.

    Hope the provided information will be helpful for you.

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top