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
80
Performance issues
posted
Hi All, I have used UltraWebGrid in my application, it is working fine in my local machine and also my local server, but in my remote server it takes more time
 
I couldn’t find the reason why?.
 
Here I have attached the sample code and it takes displaying time
            1)      in Local machine less than a second
2)      in Remote server it takes more than 38 seconds Sampl Source <igtbl:UltraWebGrid ID="uwgUserList" runat="server" Width="98%"><DisplayLayout AllowColSizingDefault="Free" AllowColumnMovingDefault="OnServer" SelectTypeRowDefault="Extended"ScrollBarView="Vertical" SelectTypeColDefault="Extended" AllowSortingDefault="Yes"ViewType="Hierarchical" SelectTypeCellDefault="Extended" BorderCollapseDefault="Separate"RowSizingDefault="Free" HeaderClickActionDefault="SortMulti" Name="uwgUserList"RowHeightDefault="20px" RowSelectorsDefault="No" Version="4.00" AutoGenerateColumns="False"CellPaddingDefault="1" CellSpacingDefault="1" StationaryMargins="HeaderAndFooter"TableLayout="Fixed"><HeaderStyleDefault CssClass="GridHeaderDispFontStyle" ForeColor="White" Width="100%"BackColor="#1A4EB4" Height="15px" Font-Size="10px" Wrap="true"></HeaderStyleDefault><FrameStyle Width="99%" Cursor="Hand" Height="150px"></FrameStyle><ActivationObject BorderStyle="None" BorderWidth="0px" BorderColor="White"></ActivationObject><RowStyleDefault HorizontalAlign="Left" CssClass="GridItemStyle" VerticalAlign="Middle"></RowStyleDefault><SelectedRowStyleDefault BackColor="#E6E6E6" VerticalAlign="Middle"></SelectedRowStyleDefault><RowExpAreaStyleDefault BackColor="#F5F8FF" VerticalAlign="Middle"></RowExpAreaStyleDefault> <Pager AllowPaging="True" PageSize="10" PagerAppearance="Bottom" QuickPages="5" StyleMode="quickPages"><Style CssClass="DispFontStyle"></Style></Pager></DisplayLayout><Bands><igtbl:UltraGridBand><Columns><igtbl:UltraGridColumn BaseColumnName="Firstname" Key="Firstname" Width="20%"><Header Caption="First Name"></Header></igtbl:UltraGridColumn><igtbl:UltraGridColumn BaseColumnName="Lastname" Key="Lastname" Width="20%"><Header Caption="Last name"></Header></igtbl:UltraGridColumn><igtbl:UltraGridColumn BaseColumnName="Email" Key="Email" Width="30%"><Header Caption="Email Address"></Header></igtbl:UltraGridColumn><igtbl:UltraGridColumn BaseColumnName="Telephone" Key="Telephone" Width="15%"><Header Caption="Telephone"></Header></igtbl:UltraGridColumn><igtbl:UltraGridColumn BaseColumnName="Mobile" Key="Mobile" Width="15%"><Header Caption="Mobile"></Header></igtbl:UltraGridColumn></Columns></igtbl:UltraGridBand></Bands></igtbl:UltraWebGrid>.CSprotected void Page_Load(object sender, EventArgs e){ DataTable dtblUserList = new DataTable();dtblUserList.Columns.Add("ID", typeof(int));dtblUserList.Columns.Add("FirstName", typeof(string));dtblUserList.Columns.Add("Lastname", typeof(string));dtblUserList.Columns.Add("Email", typeof(string));dtblUserList.Columns.Add("Telephone", typeof(string));dtblUserList.Columns.Add("Mobile", typeof(string));for (int iCount = 1; iCount < 50; iCount++){dtblUserList.Rows.Add(iCount, "First Name "+iCount,"Last Name "+iCount,"Email Address "+iCount, "23442"+iCount+"4567","99787"+iCount+"876");}uwgUserList.DataSource = dtblUserList;uwgUserList.DataBind();}  
  • 12631
    posted

    If you turn on page tracing in your web page, does that give you any clues as to where the slowdown is happening?  When I run into these situations, I usually try to find out if there might be a slowdown in the database call or even possibly IIS bandwidth throttling accidentially enabled in the production environment.

    Devin