Performance improvement in PivotGrid

[Sabaridass]

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

[Nasko]

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.

Regards,
Nasko
Telerik