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

Performance SLOW

4 Answers 298 Views

Grid

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

Mike asked on 18 Aug 2008, 02:29 PM

I am using a RadGrid with the following settings.

    
            <telerik:RadGrid ID="RadGrid1"   
        
            AllowMultiRowSelection="True"   
        
            AllowSorting="True"   
        
            AllowPaging="False"   
        
            AllowNaturalSort ="True"   
        
            AutoGenerateColumns="False"   
        
            AlternatingItemStyle-HorizontalAlign="Center"                                             
        
            BackColor="#ffffff"   
        
            HeaderStyle-HorizontalAlign="Center" 
        
            ItemStyle-HorizontalAlign="Center"   
        
            GridLines="None"   
        
            GroupingEnabled="True"   
        
            Height="370px"   
        
            OnSortCommand="RadGrid1_SortCommand"                                                       OnNeedDataSource="RadGrid1_NeedDataSource"                                                  OnItemDataBound="RadGrid1_ItemDataBound"   
        
            OnItemCommand="RadGrid1_ItemCommand"   
        
            ShowHeader="True"   
        
            ShowGroupPanel="True"   
        
            ShowStatusBar="True"   
        
            ShowFooter="False"   
        
            Skin="MySkin"    
        
            EnableEmbeddedSkins="False"   
        
            Width="98%"   
        
            runat="server">

It is calling a stored procedure that takes 4 seconds to run in PL/SQL developer. When I hook it up to the RadGrid it takes 40 seconds to load 10 X greater. When I use a regular GridView it takes 8 seconds. What is the RadGrid doing to slow the grid creation and how can I make it faster?

There are anywhere from 10-400 rows being returned.
.Net 3.5 and Ajax 2008 Q-2
Thank you!

4 Answers, 1 is accepted

answered on 21 Aug 2008, 07:07 AM

Hello George,

Please review this help topic on how to optimize RadGrid performance.
Below are listed some more suggestions:

server-side: The grid itself cannot cause server-side performance problems related to controls creations and/or render. There might be some possible problems with controls inside grid templates.
data-binding: .NET 3.5 version can handle millions of records and will apply paging, sorting and filtering directly on the data-base server (LinqDataSource) codeless: http://blogs.telerik.com/vladimirenchev/Posts/08-03-10/How_fast_is_your_ASP_NET_DataGrid.aspx?ReturnURL=%2fvladimirenchev%2fposts.aspx%3fYear%3d2008%26Month%3d3
Client-side data-binding approach is also very fast + you will get pure JSON transfer between client and server: http://blogs.telerik.com/VladimirEnchev/Posts/08-05-23/SQL_Server_sorting_paging_and_filtering_with_RadGrid_client-side_data-binding_to_WebService.aspx?ReturnURL=%2fVladimirEnchev%2fPosts.aspx
ViewState size: Some of the grid operations can work with completely turned off ViewState. Example: http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/Programming/ViewState/DefaultCS.aspx
In client-side data-binding scenarios you do not need the ViewState also. Example: http://www.telerik.com/DEMOS/ASPNET/Prometheus-futures/Grid/Examples/Client/DataBinding/DefaultCS.aspx
HTML output size: RadGrid output is the smallest on the market however may depend on selected grid features, number of items per page and templates. Example: http://www.telerik.com/DEMOS/ASPNET/Prometheus/Grid/Examples/GeneralFeatures/Migration/DefaultCS.aspx
JavaScript file size: The entire grid script size is 174 Kb (combined and compressed using dojo)

Sincerely yours,
Iana
the Telerik team

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