RadGrid slow paging

[Tom]

 

Hi, I know that this topic was raised here before but I can’t really get anywhere reading previous posts. Could someone point me in the right direction?

I have created a clear page , added radgrid, object data source and  radscriptmanager, paging enabled(10) . Objectdatasource is using dataset based on stored procedure retrieving 100k rows.  I understand that initial load time can be slow as it’s a lot of data, but I was hoping that switching between pages will be really quick.  Looking at profiler when I go form one page to another the same query is executed on sql server, I am not sure why we would query for data we already have.  Could someone tell me what I am doing wrong and what should I do to make it quicker ?

I am using: version 2011.1.519.35

Thank you for help

[Pavlina]

Hi Tom,

To speed up the paging functionality as much as possible you can take advantage of using custom paging. By using Custom paging, it is possible to fetch only a fixed number of records and perform operations over this specified set of data. Telerik RadGrid allows such data manipulation through the custom paging mechanism integrated in the control. Checkout the following link for more information about custom paging in RadGrid:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx

Other useful hints for optimizing are available in the following online resources.
http://demos.telerik.com/aspnet-ajax/grid/examples/performance/linq/defaultcs.aspx
http://www.telerik.com/products/aspnet-ajax/getting-started/top-performance.aspx

All the best,
Pavlina
the Telerik team

[Tom]

Is it normal behaviour for control to execute the same query (getting all data over and over again) when switching between pages? I had a look on you demo, and there was a grid with 300k rows working great. I wouldn’t like to overcomplicate something if it is not required.

[Pavlina]

Hello Tom,

In case you display very large amount of records in the control, you can take advantage of the LINQ queries support of RadGrid (under .NET 3.5) to speed up the performance as much as possible. This should reduce the loading time of the control to a great extent as you already noticed from our online demo.

All the best,
Pavlina
the Telerik team