Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
955
WHDG performance is very slow
posted

Hello,

I am currently using  Version 19.1.20191.231. The dataset is returning just a little over 1,800 rows with 3 bands. I have paging turned on set at 10 rows per page. Expanding the child bands or changing pages takes at least 15 to 30 seconds or more no matter how many rows are in the child bands.

Also, when using the WebExcelExporter with this grid, I have to set the ExpandAll property to get export the entire grid with the DataExportMode set to 'AllDataInDataSouce' and that takes a about 5 minutes or more to complete. 

I would appreciate any help or tips on speeding this up.  

Markup below:

<asp:SqlDataSource ID="dsGridParent" runat="server" ConnectionString="<%$ ConnectionStrings:CHPCOMSDB %>" SelectCommand="usp_Examiner_Call_Routing_Parent" SelectCommandType="StoredProcedure">
                     <SelectParameters>
                         <asp:ControlParameter ControlID="dpBeginDate" DbType="Date" Name="Begin_Date" PropertyName="Value" />
                         <asp:ControlParameter ControlID="dpEnDate" DbType="Date" Name="End_Date" PropertyName="Value" />
                         <asp:ControlParameter ControlID="hdnExamninerID" DefaultValue="" Name="Examiner_ID" PropertyName="Value" Type="String" />
                         <asp:ControlParameter ControlID="hdnManagerID" Name="Manager_ID" PropertyName="Value" Type="String" />
                         <asp:ControlParameter ControlID="ckMyTeam" DefaultValue="" Name="Just_My_Team" PropertyName="Checked" Type="Boolean" />
                     </SelectParameters>
                 </asp:SqlDataSource>
                <asp:SqlDataSource ID="dsGridChild" runat="server" ConnectionString="<%$ ConnectionStrings:CHPCOMSDB %>" SelectCommand="usp_Examiner_Call_Routing_Child" SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="dpBeginDate" DbType="Date" Name="Begin_Date" PropertyName="Value" />
                        <asp:ControlParameter ControlID="dpEnDate" DbType="Date" Name="End_Date" PropertyName="Value" />
                        <asp:ControlParameter ControlID="hdnExamninerID" Name="Examiner_ID" PropertyName="Value" Type="String" />
                        <asp:ControlParameter ControlID="hdnManagerID" Name="Manager_ID" PropertyName="Value" Type="String" />
                        <asp:ControlParameter ControlID="ckMyTeam" DefaultValue="" Name="Just_My_Team" PropertyName="Checked" Type="Boolean" />
                    </SelectParameters>
                 </asp:SqlDataSource>
                 <asp:SqlDataSource ID ="dsGridGrandChild" runat="server" ConnectionString="<%$ ConnectionStrings:CHPCOMSDB %>" SelectCommand="usp_Examiner_Call_Routing_GrandChild" SelectCommandType="StoredProcedure">
                     <SelectParameters>
                         <asp:ControlParameter ControlID="dpBeginDate" DbType="Date" Name="Begin_Date" PropertyName="Value" />
                         <asp:ControlParameter ControlID="dpEnDate" DbType="Date" Name="End_Date" PropertyName="Value" />
                         <asp:ControlParameter ControlID="hdnExamninerID" DefaultValue="" Name="Examiner_ID" PropertyName="Value" Type="String" />
                         <asp:ControlParameter ControlID="hdnManagerID" Name="Manager_ID" PropertyName="Value" Type="String" />
                         <asp:ControlParameter ControlID="ckMyTeam" DefaultValue="" Name="Just_My_Team" PropertyName="Checked" Type="Boolean" />
                     </SelectParameters>
                 </asp:SqlDataSource>
                <ig:WebHierarchicalDataSource ID="WebHierarchicalDataSource1" runat="server">
                    <DataViews>
                        <ig:DataView ID="dsGridParent_DefaultView" DataMember="DefaultView" DataSourceID="dsGridParent" />
                        <ig:DataView ID="dsGridChild_DefaultView" DataMember="DefaultView" DataSourceID="dsGridChild" />
                        <ig:DataView ID="dsGridGrandChild_DefaultView" DataMember="DefaultView" DataSourceID="dsGridGrandChild" />
                    </DataViews>
                    <DataRelations>
                        <ig:DataRelation ChildColumns="Examiner" ChildDataViewID="dsGridChild_DefaultView" ParentColumns="Examiner" ParentDataViewID="dsGridParent_DefaultView" />
                        <ig:DataRelation ChildColumns="Examiner,Call_Type" ChildDataViewID="dsGridGrandChild_DefaultView" ParentColumns="Examiner,Call_Type" ParentDataViewID="dsGridChild_DefaultView" />
                    </DataRelations>
                 </ig:WebHierarchicalDataSource>

<ig:WebHierarchicalDataGrid ID="WebHierarchicalDataGrid1" runat="server" Height="650px" Width="100%" AutoGenerateBands="False" AutoGenerateColumns="False" DataKeyFields="Examiner" DataMember="dsGridParent_DefaultView" DataSourceID="WebHierarchicalDataSource1" Key="dsGridParent_DefaultView" StyleSetName="RubberBlack">
                          <Bands>
                              <ig:Band AutoGenerateColumns="False" DataKeyFields="Examiner,Call_Type" DataMember="dsGridChild_DefaultView" Key="dsGridChild_DefaultView">
                                  <Bands>
                                      <ig:Band AutoGenerateColumns="False" DataMember="dsGridGrandChild_DefaultView" Key="dsGridGrandChild_DefaultView" DefaultColumnWidth="200px">
                                          <Columns>
                                              <ig:BoundDataField DataFieldName="Examiner" Hidden="True" Key="Examiner">
                                                  <Header Text="Examiner">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="Call_Type" Hidden="True" Key="Call_Type">
                                                  <Header Text="Call_Type">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="claimid" Key="claimid">
                                                  <Header Text="Claim ID">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="Claim_Status" Key="Claim_Status">
                                                  <Header Text="Status">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="Provider" Key="Provider">
                                                  <Header Text="Provider">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="Date_Adjudicated" Key="Date_Adjudicated">
                                                  <Header Text="Date Adjudicated">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="Ok_to_Pay_Date" Key="Ok_to_Pay_Date">
                                                  <Header Text="Ok Pay Date">
                                                  </Header>
                                              </ig:BoundDataField>
                                              <ig:BoundDataField DataFieldName="OK_to_Pay_By" Key="OK_to_Pay_By">
                                                  <Header Text="OK Pay By">
                                                  </Header>
                                              </ig:BoundDataField>
                                          </Columns>
                                          <Behaviors>
                                              <ig:Paging PageSize="10">
                                              </ig:Paging>
                                              <ig:RowSelectors RowNumbering="True">
                                              </ig:RowSelectors>
                                              <ig:ColumnResizing>
                                              </ig:ColumnResizing>
                                          </Behaviors>
                                      </ig:Band>
                                  </Bands>
                                  <Columns>
                                      <ig:BoundDataField DataFieldName="Examiner" Hidden="True" Key="Examiner">
                                          <Header Text="Examiner">
                                          </Header>
                                      </ig:BoundDataField>
                                      <ig:BoundDataField DataFieldName="Call_Type" Key="Call_Type">
                                          <Header Text="Call Type">
                                          </Header>
                                      </ig:BoundDataField>
                                      <ig:BoundDataField DataFieldName="No_of_Claims" Key="No_of_Claims" DataFormatString="{0:#,#0}">
                                          <Header Text="Claims">
                                          </Header>
                                      </ig:BoundDataField>
                                  </Columns>
                                  <Behaviors>
                                      <ig:ColumnResizing>
                                      </ig:ColumnResizing>
                                  </Behaviors>
                              </ig:Band>
                          </Bands>
                          <Columns>
                              <ig:BoundDataField DataFieldName="Examiner" Key="Examiner">
                                  <Header Text="Examiner">
                                  </Header>
                              </ig:BoundDataField>
                              <ig:BoundDataField DataFieldName="No_of_Claims" Key="No_of_Claims" DataFormatString="{0:#,#0}">
                                  <Header Text="Claims">
                                  </Header>
                              </ig:BoundDataField>
                          </Columns>
                          <Behaviors>
                              <ig:ColumnResizing>
                              </ig:ColumnResizing>
                          </Behaviors>
                      </ig:WebHierarchicalDataGrid>

   

Parents Reply Children
No Data