Radgrid Load Performance Display Only Grid

[John]

New to Radgrid and we are doing an evaluation.  We have a table that is approximately 10,000 records, and each record has  approximately 30 fields.  This grid is read only and all of the columns are GridBoundColumns.  It takes approximately 30 secs for the grid to appear, and then it takes it an additional 2-3 secs to redraw.  We have watched the Telerik TV video re optimizing grid performance with only little noticeable increases in peformance.

How can we get the grid to come up faster.

Thanks in advance for a response.

John

[Shinu]

Hi John,

Go through the following help document link which explains on optimizing the Grid performance.
Client/server grid performance optimizations

Shinu

[John]

Shinu,

Thanks for the reponse.  I tried 1,2,3(a) [see below] from the link you provided in your post all with no impact to load time.

1. Turning off all client features of the grid
2. Turning off all row-related features (row select, row click, etc.). When enabling even a single client side row functionality, the grid adds additional scripts to the page which can slow down the performance of the product.
3. Use built-in/custom paging and present only fixed set of records at a time - here are online examples for it:

I am now trying to do 3(b) use custom paging and referencing the code sample link but I am having trouble with 

using Telerik.Web.Examples.Grid;

I can not get this to resolve.  I am missing a file/reference somewhere?

Thanks,
John

 

 

[Eric Skaggs]

Was there ever any follow-up on this?  I'm having trouble with a grid as well and haven't seen any performance improvements following the link above.  I installed IE 8 this week, and that did seem to help.  In browsers other than IE, my grid's showing very little (if any) performance trouble.

[Sebastian]

Hello Eric,

Tips on how to optimize the RadGrid performance using different techniques can be found in the online resources linked below:

http://www.telerik.com/help/aspnet-ajax/gridoverview.html (Chapter "Performance tips and tricks")
http://www.telerik.com/products/aspnet-ajax/resources/top-performance.aspx
http://www.telerik.com/support/aspnet-ajax.aspx (Section "Performance")

Best regards,
Sebastian
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[John]

Eric,

No,  I have not found a solution to the problem yet.

The web page still takes over 20 secs to load with only 2000 records in the table.  I have not implemented the custom paging suggestion yet, because the total records in the table is small and from what i have read the default paging logic should handle getting a subset of records.  In provided links, I havent seen anything that says how many records would be fetched on page load using standard paging.    Maybe its getting a large portion of the 2000 records or all of them?

Interesting thing too, is that when I select a record for Edit it takes way too long to open the Popup Editor to edit one record.  If I do not even edit the record in the Pop-Up and hit cancel it takes another long lag time for the popup to disappear and grid to refresh/reload??

Same query on database from SQL Server or other tools is very fast??

Good luck with your issue.  I will keep you posted on my solution via this thread.  Let me know if you find something.

[Edward]

Heads up Telerik my RadGrid performance is pretty poor as well.  Any additional thoughts on this thread?

[Sebastian]

Hello Edward,

Have you reviewed the resources elaborating on performance optimizations linked previously in this forum thread? Are they helpful to you? Moreover, you can examine the demos from the 'Performance' section of the RadGrid QSF which apply those methods in reality:

http://demos.telerik.com/aspnet-ajax/grid/examples/overview/defaultcs.aspx 

I hope you will find these pointers useful.

Kind regards,

Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.