When using data from Database, the only way to get correct results in RadPivotGrid
is to get all items from the table and set them as ItemsSource of LocalDataSourceProvider
. The amount of items that you can use as ItemsSource depends on the machine that is used and its hardware specification. This is because the items from the Database will be saved in the memory of the PC. Unfortunately there's no better way to achieve this. You can take a look at our XmlaDataProvider here
, but you'll have to setup a cube from your database. This will boost the performance as the data will be aggregated in the cube itself and access to it will be much faster.
Hope this helps.
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos
and start improving your app based on facts, not hunches.