I have a WebHierarchicalDataGrid that uses two stored procedures to fill the grid.  This code previously worked correctly with a page load time of just a few seconds in 2010 volume 3.  When we upgraded to 2011 volume 1, the load time increased to several minutes.  The top level grid has roughly 2000 rows of data and the second level has roughly 14000.  With the EnableAjax property set to true it times out whenever we attempt to expand the child rows.  When I set it to false the page works, it just takes a long time.  With an InitialBindDepth of 1it will take a long time to load and then afterwards the page works correctly.  I am assuming that it is attempting to load all the rows whenever I interact with the grid.  This was not the case in 2010 volume 3.  Is there something that I need to change in order for this to just process a single page at a time? 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

<

 

 

ig:WebHierarchicalDataGrid ID="whdgEquipment" runat

="server"

 

 

DataSourceID="whdg_dataSource" DataKeyFields="SEQNUM" InitialDataBindDepth

="0"

 

 

AutoGenerateColumns="False" AutoGenerateBands="false" Width

="95%"

 

 

StyleSetName="Claymation" StyleSetPath="../Infragistics Themes/ig_res" AjaxIndicator-Enabled="True"

 

 

AjaxIndicator-ImageUrl="../images/ajax_activity_indicator.gif" AjaxIndicator-RelativeToControl="False"

 

 

AjaxIndicator-Location="MiddleCenter" EnableAjax

="true">

 

 

 

<Columns

>

 

 

 

<ig:TemplateDataField Key="PS_SELECT" Width

="10%">

 

 

<ItemTemplate

>

 

 

<asp:Button ID="btnPSSelect" Height="20px" runat="server" Text="Select" CausesValidation="False" UseSubmitBehavior

="false"

 

 

CommandArgument='<%# Eval("SEQNUM") %>' CommandName="PSSelect"

 

 

OnCommand="PSClick"></asp:Button

>

 

 

</ItemTemplate

>

 

 

</ig:TemplateDataField

>

 

 

 

<ig:BoundDataField DataFieldName="SEQNUM" Key="SEQNUM" Hidden

="true">

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="MANUFACTURER" Header-Text="Manufacturer"

 

 

Key

="MANUFACTURER">

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="PARTNUM" Header-Text="Part #"

 

 

Key

="PARTNUM">

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="MODELNUM" Header-Text="Model #" Key

="MODELNUM">

 

 

 

</ig:BoundDataField

>

 

 

 

 

 

 

</Columns

>

 

 

<Bands

>

 

 

<ig:Band AutoGenerateColumns="false" DataKeyFields

="SEQNUM"

 

 

DataMember="dv_assets" Key="FILTERED_ASSETS" Width

="90%">

 

 

<Columns>

 

 

 

 

<ig:TemplateDataField Key="ASSET_SELECT" Width

="10%">

 

 

<ItemTemplate

>

 

 

<asp:Button ID="btnAssetSelect" runat="server" Text="Select" CausesValidation="False" UseSubmitBehavior

="false"

 

 

CommandArgument='<%# Eval("SEQNUM") %>' CommandName="AssetSelect"

 

 

OnCommand="AssetClick"></asp:Button

>

 

 

</ItemTemplate

>

 

 

</ig:TemplateDataField

>

 

 

 

<ig:BoundDataField DataFieldName="SEQNUM" Key="SEQNUM" Hidden="true"

>

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="PRODUCT_STRUCTURE_SEQNUM" Key="PRODUCT_STRUCTURE_SEQNUM" Hidden="true"

>

 

 

 

</ig:BoundDataField

>

 

 

<ig:BoundDataField DataFieldName="SERIALNUM" Header-Text="Serial #"

 

 

Key

="SERIALNUM">

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="BARCODE" Header-Text="Barcode"

 

 

Key

="BARCODE">

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="UIC" Header-Text="UIC"

 

 

Key

="UIC">

 

 

 

</ig:BoundDataField

>

 

 

 

<ig:BoundDataField DataFieldName="UPDATESTAMP" Header-Text="Last Updated"

 

 

Key

="UPDATESTAMP">

 

 

 

</ig:BoundDataField

>

 

 

 

</Columns

>

 

 

 

 

</ig:Band

>

 

 

</Bands

>

 

 

<Behaviors

>

 

 

<ig:Paging PagerAppearance="Bottom" PageSize="20" Enabled="true"

/>

 

 

 

 

<ig:Sorting SortingMode="Single" Enabled

="true">

 

 

<ColumnSettings

>

 

 

<ig:SortingColumnSetting ColumnKey="SEQNUM" Sortable="false"

/>

 

 

</ColumnSettings

>

 

 

</ig:Sorting>

 

 

 

 

</Behaviors>

 

 

 

<CollapseButton AltText="Collapse Row"

/>

 

 

<ExpandButton AltText="Expand Row"

/>

 

 

 

</ig:WebHierarchicalDataGrid

>

 

 

 

<ig:WebHierarchicalDataSource ID="whdg_dataSource"

 

 

runat

="server">

 

 

<DataRelations

>

 

 

<ig:DataRelation ChildDataViewID="dv_assets" ParentDataViewID="dv_prodstructures"

 

 

ChildColumns="PRODUCT_STRUCTURE_SEQNUM" ParentColumns="SEQNUM"

/>

 

 

</DataRelations

>

 

 

<DataViews

>

 

 

<ig:DataView ID="dv_prodstructures" DataSourceID="sdsProdStructure"

/>

 

 

<ig:DataView ID="dv_assets" DataSourceID="sdsAssets"

/>

 

 

</DataViews

>

 

 

 

</ig:WebHierarchicalDataSource

>

 

 

<asp:SqlDataSource ID="sdsProdStructure" runat="server"

 

 

 

ProviderName="Oracle.DataAccess.Client"

 

 

SelectCommand="CIMS.ASSET_FILTERS.GET_FILTERED_PRODSTRUCTURES"

 

 

OnSelecting="sds_Selecting"

 

 

SelectCommandType

="StoredProcedure">

 

 

<SelectParameters

>

 

 

<asp:SessionParameter name="VAR_PROGRAM_SEQNUM" SessionField="VAR_PROGRAM_SEQNUM"

/>

 

 

<asp:SessionParameter name="VAR_EXTRA_FROM" SessionField="VAR_EXTRA_FROM"

/>

 

 

<asp:SessionParameter name="VAR_WHERE" SessionField="VAR_WHERE"

/>

 

 

<asp:Parameter Name="FILTERED_PS" Direction="Output"

/>

 

 

</SelectParameters

>

 

 

 

</asp:SqlDataSource

>

 

 

<asp:SqlDataSource ID="sdsAssets" runat="server"

 

 

ProviderName="Oracle.DataAccess.Client"

 

 

SelectCommand="CIMS.ASSET_FILTERS.GET_FILTERED_ASSETS"

 

 

OnSelecting="sds_Selecting"

 

 

SelectCommandType

="StoredProcedure">

 

 

<SelectParameters

>

 

 

<asp:SessionParameter name="VAR_PROGRAM_SEQNUM" SessionField="VAR_PROGRAM_SEQNUM"

/>

 

 

<asp:SessionParameter name="VAR_EXTRA_FROM" SessionField="VAR_EXTRA_FROM"

/>

 

 

<asp:SessionParameter name="VAR_WHERE" SessionField="VAR_WHERE"

/>

 

 

<asp:Parameter Name="FILTERED_ASSETS" Direction="Output"

/>

 

 

</SelectParameters

>

 

 

</asp:SqlDataSource

>