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

Sorting Speed

1 Answer 28 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jeff Tang
Top achievements
Rank 1
Jeff Tang asked on 03 Dec 2008, 08:52 AM

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

Sort by
0
Shinu
Top achievements
Rank 2
answered on 03 Dec 2008, 09:23 AM
Hi Jeff,

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

Tags
Grid
Asked by
Jeff Tang
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or