Load data for each grid page as needed

[Jeff]

We have a paged grid that loads the results of a stored procedure that returns over 100,000 results. We're experiencing some performance delays. Is there a way to have the grid only return the required results for the page it is on? We understand that we will need to modify the stored procedure also but aren't clear how to get the grid itself to make the right call for the particular page.

[Pavlina]

Hello,

In order to achieve your goal you can try implementing Custom Paging as demonstrates in the demo below:
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/paging/custom-paging/defaultcs.aspx

Additional information how to optimize the grid performance is available in the following article:
http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/performance/grid-performance-optimizations

Regards,
Pavlina
Telerik

[Jeff]

Thank you for the links. We had looked at those pages previously but will dig into them deeper. thanks

[Pavlina]

Hi,

Give them a try and let us know in case you need additional assistance.

Regards,
Pavlina
Telerik