Performance SLOW

[Mike]

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!

[Mike]

Is anyone out there?

[Mike]

I still have not heard anything from Telerik??  Could you please help on this?

[Iana Tsolova]

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.

[Mike]

Thank you, I was starting to worry no one was going to respond.  It looks like I have several options here.  Time to start going through them.