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

Performance improvement in PivotGrid

1 Answer 32 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Sabaridass
Top achievements
Rank 1
Sabaridass asked on 15 Dec 2015, 08:56 AM

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

1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 04 Jan 2016, 09:10 AM
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
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
Tags
PivotGrid
Asked by
Sabaridass
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or