Load data for each grid page as needed

4 posts, 0 answers
  1. Jeff
    Jeff avatar
    38 posts
    Member since:
    Jan 2008

    Posted 20 Nov 2015 Link to this post

    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.
  2. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 23 Nov 2015 Link to this post

    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
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Jeff
    Jeff avatar
    38 posts
    Member since:
    Jan 2008

    Posted 23 Nov 2015 in reply to Pavlina Link to this post

    Thank you for the links. We had looked at those pages previously but will dig into them deeper. thanks
  5. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 24 Nov 2015 Link to this post

    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
Back to Top