Hello,
I'm using OLAP connection to pivot grid, I have noticed that when i use the paging also Pivot Grid queries for the whole data set and displays the current page, on every page shift it does the same without using the initially retrieved data set or requesting for the current dataset. Its a huge performance hit in my case. is it possible to avoid this?
Regards,
Yohan
I'm using OLAP connection to pivot grid, I have noticed that when i use the paging also Pivot Grid queries for the whole data set and displays the current page, on every page shift it does the same without using the initially retrieved data set or requesting for the current dataset. Its a huge performance hit in my case. is it possible to avoid this?
Regards,
Yohan
1 Answer, 1 is accepted
0
Hi Yohan,
The whole data need to be get in order to be grouped and totals to be calculated. To avoid multiple calls to the server you can enable the data caching of RadGrid by setting EnableCaching="true".
Regards,
Vasil
Telerik
The whole data need to be get in order to be grouped and totals to be calculated. To avoid multiple calls to the server you can enable the data caching of RadGrid by setting EnableCaching="true".
Regards,
Vasil
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.