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?
Telerik Feedback Portal
and vote to affect the priority of the items