I have the follwing grid which contains 1500 rows. if I try to sort on a column, it takes over twenty seconds. Is there any way to speed up the sorting?
<telerik:RadGrid ID="rgAdvSearch" runat="server"
AllowSorting="True" AutoGenerateColumns="False" GridLines="None"
Skin="WebBlue" Width="100%" AllowMultiRowSelection="True">
<SelectedItemStyle BackColor="#99CCFF" />
<ClientSettings>
<Selecting AllowRowSelect="True" />
<ClientEvents OnRowDblClick="Row_Select" OnRowClick="Row_Single_Click" />
<Scrolling AllowScroll="True" />
</ClientSettings>
<MasterTableView PageSize="30" EnableViewState="true"
ClientDataKeyNames="type, start_time, end_time, nature_cct, status_ss, ref_no, intrp_no, match_lid"
Width="98%">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridCheckBoxColumn CurrentFilterFunction="NoFilter"
DataField="match_lid" FilterListOptions="VaryByDataType"
ForceExtractValue="None" HeaderText="Match LID"
UniqueName="match_lid1">
<ItemStyle Width="1px" />
<FooterStyle Width="1px" />
<HeaderStyle Height="1px" Width="70px" />
</telerik:GridCheckBoxColumn>
<telerik:GridBoundColumn DataField="type" HeaderText="Type" UniqueName="type">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="start_time" DataType="System.DateTime"
HeaderText="Start Time" UniqueName="start_time" DataFormatString="{0:dd/MM/yyyy HH:mm:ss}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="end_time" DataType="System.DateTime"
HeaderText="End Time" UniqueName="end_time" DataFormatString="{0:dd/MM/yyyy HH:mm:ss}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="nature_cct" HeaderText="Nature / Cct No."
UniqueName="nature_cct">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="status_ss"
HeaderText="Status / Substation / Description" UniqueName="status_ss">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ref_no" HeaderText="Ref. No."
UniqueName="ref_no" Aggregate="Count">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="intrp_no" UniqueName="intrp_no" Visible = "false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="match_lid" UniqueName="match_lid" Visible = "false">
</telerik:GridBoundColumn>
</Columns>
<PagerStyle Mode="NextPrevNumericAndAdvanced" />
<HeaderStyle Font-Bold="True" Font-Italic="False" Font-Overline="False"
Font-Strikeout="False" Font-Underline="False" ForeColor="Black" Wrap="True" />
</MasterTableView>
<FilterMenu EnableTheming="True" Skin="WebBlue">
<CollapseAnimation Duration="200" Type="OutQuint" />
</FilterMenu>
</telerik:RadGrid>
1 Answer, 1 is accepted
Rank 2
I am not sure about the cause of this problem. But one suggestion will be to set AllowPaging to true in the Grid and set PageSize to a smaller value to improve the Grid performance.
Client/server grid performance optimizations
Shinu