This is a migrated thread and some comments may be shown as answers.

Load data for each grid page as needed

3 Answers 30 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jeff
Top achievements
Rank 1
Jeff asked on 20 Nov 2015, 04:34 PM
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.

3 Answers, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 23 Nov 2015, 04:01 PM
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
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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Jeff
Top achievements
Rank 1
answered on 23 Nov 2015, 06:23 PM
Thank you for the links. We had looked at those pages previously but will dig into them deeper. thanks
0
Pavlina
Telerik team
answered on 24 Nov 2015, 06:00 PM
Hi,

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

Regards,
Pavlina
Telerik
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? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Grid
Asked by
Jeff
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Jeff
Top achievements
Rank 1
Share this question
or