Hierarchical WebGrid unusable due to poor performance

SAgosto — Tue, 18 Jan 2011 17:59:36 GMT

I have a hierarchical WebGrid that is unuseable due to slow performance. The actual query used to bind the grid takes ~6-7 seconds but the majority of time being the rendering. Using VirtualLoad w/ 200 page size, the load time is ~1:57min. Using Classing Paging w/ 200 page size, the load time is ~1:16 min. Decreasing the page size to 50, the load time is ~30 secs. Removing the hierarchy that is defined within the server-side code, the VirtualLoad w/200 page size loads in ~34sec. while the Classing Paging w/ 200 page size loads in ~29sec., and the 50 page size loads in ~ 15sec.

Please assist. Thanks.

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="TransList.ascx.cs" Inherits="Endurance.Re.FWB.Web.FWBWebControls.Transaction.TransList" %>

<%@ Register assembly="ISNet.WebUI.WebGrid" Namespace="ISNet.WebUI.WebGrid" TagPrefix="ISWebGrid" %>

<%@ Register assembly="ISNet.WebUI.WebDesktop" Namespace="ISNet.WebUI.WebDesktop" TagPrefix="ISWebDesktop" %>

<CommonCtrl:EnduranceWebGrid runat="server" ID="grdTransList"

DefaultStyleMode="Elegant" UseDefaultStyle="True"

Width="100%" Height="100%"

EnableViewState="false" ViewStateStorage="None"

OnPreInitialize="grdTransList_OnPreInitialize"

OnInitializeDataSource="grdTransList_OnInitializeDataSource"

OnInitializeLayout="grdTransList_OnInitializeLayout"

OnInitializeRow="grdTransList_OnInitializeRow"

OnInitializePostback="grdTransList_OnInitializePostBack"

OnPrepareDatabinding="grdTransList_OnPrepareDataBinding"

OnExport="grdTransList_OnExport">

<LayoutSettings

Hierarchical="true" HierarchicalMode="Preload"

AutoHeight="True"

RowHeightDefault="22px"

AllowFilter="Yes"

AllowSelectColumns="Yes"

AllowSorting="Yes"

HideColumnsWhenGrouped="Default"

NewRowLostFocusAction="AlwaysPrompt"

ResetNewRowValuesOnError="False"

InProgressUIBehavior="ChangeCursorToHourGlass"

ApplyFiltersKey="Enter"

AllowColumnFreezing="Yes"

ShowFilterStatus="True"

VerboseEditingInformation="False"

FilterBarVisible="True"

CellPaddingDefault="0"

AlwaysShowHelpButton="False"

AllowExport="Yes" PagingExportMode="ExportAllData"

PagingMode="VirtualLoad" VirtualPageSize="200">

</BorderSettings>

</FrameStyle>

<StatusBarCommandStyle Active-CssClass="WebGridStatusBarCommandStyleActive"

Normal-CssClass="WebGridStatusBarCommandStyleNormal"

Over-CssClass="WebGridStatusBarCommandStyleOver" >

</StatusBarCommandStyle>

<FreezePaneSettings AbsoluteScrolling="True"

ActiveFrozenColumns="4"

ShowInContextMenu="False"

ShowSplitterLine="False"

MaxFrozenColumns="4"

SplitterLineColor="ActiveBorder"

SplitterLineWidth="1" />

</LayoutSettings>

<ISWebGrid:WebGridColumn Caption="" DataMember="TransactionHeaderID" DataType="System.String"

EditType="NoEdit" Name="TransactionHeaderID" Width="0px" Visible="false" />

<ISWebGrid:WebGridColumn Caption="" DataMember="IsTransactionListProcessable" DataType="System.String"

EditType="NoEdit" Name="IsTransactionListProcessable" Width="0px" Visible="false" />

<ISWebGrid:WebGridColumn Caption=" " Name="TreatyProcessButton" DataMember="" HiddenDataMember="TransactionHeaderID" DataType="System.String"

Width="65px" ButtonText="Treaty Process" ColumnType="Template" EditType="NoEdit" NewRowEditType="NoEdit" Bound="true">

</ButtonStyle>

<img runat="server" id="imgTreatyProcess" name="imgTreatyProcess" src="~/Images/Buttons/process_off.gif" alt="Process the treaty"

border="0" style="padding-top: 1px;"

onclick="javascript:treatyProcess();" onmouseout="javascript:MM_swapImgRestore()" onmouseover="javascript:MM_swapImage(this.id,'','../../Images/Buttons/process_on.gif',1)" />

</CellTemplate>

</ISWebGrid:WebGridColumn>

<ISWebGrid:WebGridColumn Caption="" FilterEditType="NoEdit" ColumnType="Image"

EditType="NoEdit" Name="TransactionHeaderStatusIcon" Width="20px" />

<ISWebGrid:WebGridColumn Caption="Status" DataMember="TransactionHeaderStatusName" FilterEditType="TextBox"

EditType="NoEdit" Name="TransactionHeaderStatusName" Width="80px" />

<ISWebGrid:WebGridColumn Caption="Treaty" DataMember="MasterReference" FilterEditType="TextBox" DataType="System.String"

EditType="NoEdit" Name="MasterReference" Width="100px" />

<ISWebGrid:WebGridColumn Caption="Transaction" DataMember="AccountingTransactionTypeCode" FilterEditType="TextBox" DataType="System.String"

EditType="NoEdit" Name="AccountingTransactionTypeCode" Width="80px" />

<ISWebGrid:WebGridColumn Caption="Transaction Description" DataMember="TransactionHeaderDescription" FilterEditType="TextBox" DataType="System.String"

EditType="NoEdit" Name="TransactionHeaderDescription" Width="200px" />

<ISWebGrid:WebGridColumn Caption="Assigned To" DataMember="AssignedTo" FilterEditType="TextBox" DataType="System.String"

EditType="NoEdit" Name="AssignedTo" Width="100px" />

<ISWebGrid:WebGridColumn Caption="Assigned On" DataMember="AssignedOn" FilterEditType="CalendarCombo" DataType="System.DateTime"

EditType="NoEdit" Name="AssignedOn" Width="100px" />

<ISWebGrid:WebGridColumn Caption="Created By" DataMember="CreatedBy" FilterEditType="TextBox" DataType="System.String"

EditType="NoEdit" Name="CreatedBy" Width="100px" />

<ISWebGrid:WebGridColumn Caption="Created On" DataMember="CreatedOn" FilterEditType="CalendarCombo" DataType="System.DateTime"

EditType="NoEdit" Name="CreatedOn" Width="100px" />

<ISWebGrid:WebGridColumn Caption="" DataMember="TransactionHeaderStatusID" Name="TransactionHeaderStatusID" Visible="false" />

</Columns>

</RootTable>

</CommonCtrl:EnduranceWebGrid>

</div>

#region using

using System;

using System.Collections;

using System.Collections.Generic;

using System.Drawing;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using ISNet.WebUI;

using ISNet.WebUI.WebDesktop;

using ISNet.WebUI.WebGrid;

using Endurance.Re.Common.Data;

using Endurance.Re.Common.Utility;

using Endurance.Re.FWB.Web.Controllers;

using Endurance.Re.FWB.Web.Classes;

using Endurance.Re.FWB.Data;

using Endurance.Re.FWB.Utility;

#endregion using

namespace Endurance.Re.FWB.Web.FWBWebControls.Transaction

{

/// <summary>

/// Transaction List class

/// </summary>

public partial class TransList : BaseUserControl

{

#region Constants

private const string VIEWSTATE_FILTERTYPE = "ViewState_FilterType";

private const string TOOLBAR_FUNCTIONS_CREATENEWTRANSACTION = "cmdCreateNewTransaction";

#endregion Constants

#region Variables

private Controllers.FWBWebControls.Transaction.TransListController _controllerTransList = null;

#endregion Variables

#region Properties

/// <summary>

/// Transaction List Controller

/// </summary>

public new Controllers.FWBWebControls.Transaction.TransListController Controller

{

get

{

if (this._controllerTransList == null) { this._controllerTransList = new Controllers.FWBWebControls.Transaction.TransListController(this.Page.UserID); }

return this._controllerTransList;

}

set { this._controllerTransList = value; }

}

/// <summary>

/// Filter Type

/// </summary>

public Data.TransactionList.FilterTypes FilterType

{

get { return (Data.TransactionList.FilterTypes)(this.ViewState[TransList.VIEWSTATE_FILTERTYPE] ?? Data.TransactionList.FilterTypes.MyRecent); }

set { this.ViewState[TransList.VIEWSTATE_FILTERTYPE] = value; }

}

/// <summary>

/// Transaction List grid control's Refresh Interval

/// </summary>

protected int RefreshTransListGridInterval

{

get { return (AppSettings.TransList_Refresh_Interval > 0) ? AppSettings.TransList_Refresh_Interval : 0; }

}

#endregion Properties

#region Constructors

/// <summary>

/// TransList constructor

/// </summary>

public TransList()

{

// Do nothing

}

#endregion Constructors

#region Event Handlers

#region Page

/// <summary>

/// Handles the page's Load event

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event Arguments</param>

protected void Page_Load(object sender, EventArgs e)

{

// Initialize the page

this.InitPage((this.Page.IsPostBack == false));

}

#endregion Page

#region Controls

#region Transaction List Grid

/// Handles the TransList DataGrid control's OnPreInitialize event

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event Arguments</param>

protected void grdTransList_OnPreInitialize(object sender, EventArgs e)

{

// Load the Transaction List grid control's Hierarchical Object Relations

this.LoadTransListGridHierarchicalObjectRelations();

}

/// <summary>

/// Handles the Transaction List grid control's OnInitializeLayout event

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void grdTransList_OnInitializeLayout(object sender, ISNet.WebUI.WebGrid.LayoutEventArgs e)

{

// Initialize

if (e == null) { return; }

e.Layout.ClientSideEvents.OnBeforeRequest = CommonConstants.JAVASCRIPT_COMMON_WEBGRID_SAVESCROLLPOSITION;

}

/// <summary>

/// Handles the Transaction List grid control's OnInitializeDataSource event

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event arguments</param>

protected void grdTransList_OnInitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)

{

// Get transaction data

if (e == null) { return; }

e.DataSource = this.Controller.GetTransactionListData(this.FilterType, base.Page.CurrentMasterNumber, base.Page.CurrentMasterSequence, this.Page.UserID);

}

/// <summary>

/// Handles the TransList DataGrid control's OnPrepareDataBinding event

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event Arguments</param>

protected void grdTransList_OnPrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)

{

// Load Transaction List grid control's hierarchical structure

this.LoadTransListGridHierarchicalStructure();

}

/// <summary>

/// Handles the Transaction List grid control's OnInitializeRow event used to perform row level initialization.

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event arguments</param>

protected void grdTransList_OnInitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)

{

}

/// <summary>

/// Handles the Transaction List grid control's OnInitializePostBack event handler. Fired on a full or on the fly postback.

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event Arguments</param>

protected void grdTransList_OnInitializePostBack(object sender, ISNet.WebUI.WebGrid.PostbackEventArgs e)

{

}

/// <summary>

/// Handles the Transaction List grid control's OnExport event

/// </summary>

/// <param name="sender">Sender</param>

/// <param name="e">Event arugments</param>

protected void grdTransList_OnExport(object sender, ExportEventArgs e)

{

if (e == null) { return; }

e.ReportInfo.EnableValueList = true;

e.ReportInfo.DisablePaging = true;

}

#endregion Transaction List Grid

#endregion Controls

#endregion Event Handlers

#region Methods

/// <summary>

/// Initialize the page

/// </summary>

/// <param name="initalize">Initialize</param>

private void InitPage(bool initalize)

{

}

/// <summary>

/// Load the Transaction List grid control's Hierarchical Object Relations

/// </summary>

private void LoadTransListGridHierarchicalObjectRelations()

{

// Defines object relationships between parent/child

ArrayList objectRelations = new ArrayList();

objectRelations.Add(new WebGridObjectRelation(

typeof(List<Data.TransactionList>), Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONHEADER_ID, Data.Constants.DATABASE_TABLE_TRANSACTIONQUEUE_NAME,

typeof(List<Data.TransactionQueue>), Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONHEADER_ID));

// Defines the Parent and Child Type information

// objectTypes contains 3 object array: The parent collection type, child item type, the

// primary keys of child collection Primary keys can be string (if only 1 primary key

// defined), or array of string for multiple primary keys scenario.

ArrayList objectTypes = new ArrayList();

objectTypes.Add(new object[] {

typeof(List<Data.TransactionList>), typeof(Data.TransactionList), Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONHEADER_ID});

objectTypes.Add(new object[] {

typeof(List<Data.TransactionQueue>), typeof(Data.TransactionQueue), Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_ID});

this.grdTransList.SetObjectRelations(objectRelations, objectTypes);

}

/// <summary>

/// Load the Transaction List grid control's hierarchical structure

/// </summary>

/// <remarks>The RootTable is defined on the client while the child tables are defined here per Intersoft</remarks>

private void LoadTransListGridHierarchicalStructure()

{

if (this.Page.IsPostBack == false)

{

// Transaction Queue Child Table

this.grdTransList.RootTable.ChildTables.Add(Data.Constants.DATABASE_TABLE_TRANSACTIONQUEUE_NAME);

WebGridTable transactionQueue = this.grdTransList.RootTable.ChildTables[0];

transactionQueue.DataMember = Data.Constants.DATABASE_TABLE_TRANSACTIONQUEUE_NAME;

transactionQueue.DataKeyField = Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_ID;

// Transaction Queue's Status Icon

WebGridColumn transactionQueueStatusIcon = new WebGridColumn(Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_STATUS_ICON, "");

transactionQueueStatusIcon.ColumnType = ISNet.WebUI.WebGrid.ColumnType.Image;

transactionQueueStatusIcon.Width = new Unit("20px");

transactionQueue.Columns.Add(transactionQueueStatusIcon);

// Transaction Queue's Status Name

WebGridColumn transactionQueueStatusName = new WebGridColumn(Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_STATUS_NAME,

Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_STATUS_NAME, "Status");

transactionQueueStatusName.Width = new Unit("80px");

transactionQueue.Columns.Add(transactionQueueStatusName);

// Transaction Queue's Reference Value

WebGridColumn referenceValue = new WebGridColumn(Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_REFERENCE_VALUE,

Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_REFERENCE_VALUE, "Reference #");

referenceValue.Width = new Unit("100px");

transactionQueue.Columns.Add(referenceValue);

// Transaction Queue's Error Message

WebGridColumn errorMessage = new WebGridColumn(Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_ERRORMESSAGE,

Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_ERRORMESSAGE, "Error");

errorMessage.Width = new Unit("100%");

transactionQueue.Columns.Add(errorMessage);

// Transaction Queue's Status ID

WebGridColumn transactionQueueStatusID = new WebGridColumn(Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_STATUS_ID,

Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_STATUS_ID,

Data.Constants.SP_COL_TRANSACTIONLIST_TRANSACTIONQUEUE_STATUS_ID);

transactionQueueStatusID.Visible = false;

transactionQueue.Columns.Add(transactionQueueStatusID);

}

this.grdTransList.LayoutSettings.Hierarchical = true;

this.grdTransList.LayoutSettings.HierarchicalMode = HierarchicalOperation.Preload;

}

/// <summary>

/// Default Implementation - does nothing as save is not required for this control.

/// </summary>

public override void Save()

{

// Do nothing

}

#endregion Methods

}

Intersoft Community - WebGrid Enterprise - Hierarchical WebGrid unusable due to poor performance

Hierarchical WebGrid unusable due to poor performance

Hierarchical WebGrid unusable due to poor performance

Hierarchical WebGrid unusable due to poor performance

Hierarchical WebGrid unusable due to poor performance