We are testing the grid connecting to a table with a million of records. We are using paging but it take time to load the next page. We do not want to use LINQ. How can we speed up this operation?
Thanks
3 Answers, 1 is accepted
0
Sebastian
Telerik team
answered on 06 Mar 2009, 11:35 AM
Hi Marietta,
Have you considered taking advantage of the custom paging feature of our web grid? Thus only a subset of records visible on the rendered page will be fetched from the underlying source.
Other useful tips how to optimize the performance of the control can be found in these resources:
I also have a thread open about grid performance, where custom paging was suggested as a possible solution but I am unable to get the example to work that you referenced(and Shinu) as I can not find "Telerik.Web.Examples.Grid". Where can I download the file from? Also here is a link to my post, as maybe you might have some additional insight:
The class used for the ObjectDataSource TypeName resides in the App_Code/Grid subfolder in the RadControls for ASP.NET AJAX installation folder. The default location is pointed below:
C:\Program Files\telerik\RadControls for ASPNET AJAX QX 200X\Live Demos\App_Code\Grid