Radgrid Load Performance Display Only Grid

8 posts, 0 answers
  1. John
    John avatar
    20 posts
    Member since:
    Mar 2009

    Posted 03 Mar 2009 Link to this post

    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
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 03 Mar 2009 Link to this post

    Hi John,

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

    Shinu
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. John
    John avatar
    20 posts
    Member since:
    Mar 2009

    Posted 04 Mar 2009 Link to this post

    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

     

     

  5. Eric Skaggs
    Eric Skaggs avatar
    39 posts
    Member since:
    Nov 2008

    Posted 30 Mar 2009 Link to this post

    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.
  6. Sebastian
    Admin
    Sebastian avatar
    9934 posts

    Posted 31 Mar 2009 Link to this post

    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.
  7. John
    John avatar
    20 posts
    Member since:
    Mar 2009

    Posted 31 Mar 2009 Link to this post

    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.
  8. Edward
    Edward avatar
    20 posts
    Member since:
    Mar 2009

    Posted 05 May 2009 Link to this post

    Heads up Telerik my RadGrid performance is pretty poor as well.  Any additional thoughts on this thread?
  9. Sebastian
    Admin
    Sebastian avatar
    9934 posts

    Posted 06 May 2009 Link to this post

    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.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017