need some guggession for speeding up of web page
-
Hi all, I am using C# , asp.net2.0 , ajax1.0 and sql server 2005. I am facing problem of slowness of web http://www.bbraunconnect.co.in/HRMS/DailyCallReport/DCR.aspx please click on the link ,this link will ask username and password . username is em194 and password is TEST123@ let me explain the problem. you will find subdivision .On its selection product dropdownlist is filled but it is consuming some time on main server(where database and code are not on the same machine ) whereas in test server (where database and code are on the same machine ) it does not consume any time I would like to know how to I speed up the process. let me explain how I am filling the control I made one class and defined method as shown below (earlier I tried by making datatable and filling in table but it was taking higher timespan then this )
public void FillctrlList2(DropDownList ctrl, string procedurename,string fieldtext ,string fieldvalue , string conn, SqlCommand cmd, int i) { try { if (con == null) { this.openconnection(conn); this.con.Open(); // con.Open(); } if (con.State == ConnectionState.Closed) { this.openconnection(conn); con.Open(); } ctrl.Items.Clear(); ctrl.Items.Add(new ListItem("Select One", "0")); cmd.Connection = con; cmd.CommandText = procedurename; cmd.CommandType = CommandType.StoredProcedure; rdr = cmd.ExecuteReader(); ctrl.DataSource = rdr; ctrl.DataTextField = fieldtext; ctrl.DataValueField = fieldvalue; ctrl.DataBind(); } catch (Exception ex) { throw ex; } finally { if (rdr != null) { rdr.Close(); } if (con != null) { con.Close(); } } } I have web config connection as <add name="bbraunemisconnectstring" connectionString="Data Source=bindh2,1433;Initial Catalog=bbraun_emis;User ID=sa;Password=LITTLEANGEL" providerName="System.Data.SqlClient"/>data is also not much in the table it 500 to 600 and also i am using ajax updatepanel too. The procedure I am using to fetch the data isALTER PROCEDURE [dbo].[SPGETPRODUCT_G -
Hi all, I am using C# , asp.net2.0 , ajax1.0 and sql server 2005. I am facing problem of slowness of web http://www.bbraunconnect.co.in/HRMS/DailyCallReport/DCR.aspx please click on the link ,this link will ask username and password . username is em194 and password is TEST123@ let me explain the problem. you will find subdivision .On its selection product dropdownlist is filled but it is consuming some time on main server(where database and code are not on the same machine ) whereas in test server (where database and code are on the same machine ) it does not consume any time I would like to know how to I speed up the process. let me explain how I am filling the control I made one class and defined method as shown below (earlier I tried by making datatable and filling in table but it was taking higher timespan then this )
public void FillctrlList2(DropDownList ctrl, string procedurename,string fieldtext ,string fieldvalue , string conn, SqlCommand cmd, int i) { try { if (con == null) { this.openconnection(conn); this.con.Open(); // con.Open(); } if (con.State == ConnectionState.Closed) { this.openconnection(conn); con.Open(); } ctrl.Items.Clear(); ctrl.Items.Add(new ListItem("Select One", "0")); cmd.Connection = con; cmd.CommandText = procedurename; cmd.CommandType = CommandType.StoredProcedure; rdr = cmd.ExecuteReader(); ctrl.DataSource = rdr; ctrl.DataTextField = fieldtext; ctrl.DataValueField = fieldvalue; ctrl.DataBind(); } catch (Exception ex) { throw ex; } finally { if (rdr != null) { rdr.Close(); } if (con != null) { con.Close(); } } } I have web config connection as <add name="bbraunemisconnectstring" connectionString="Data Source=bindh2,1433;Initial Catalog=bbraun_emis;User ID=sa;Password=LITTLEANGEL" providerName="System.Data.SqlClient"/>data is also not much in the table it 500 to 600 and also i am using ajax updatepanel too. The procedure I am using to fetch the data isALTER PROCEDURE [dbo].[SPGETPRODUCT_G500-600 records is still quite a lot of data to display in one go. Do your users actually need to see this many records at one time? The amount of HTML required to render out all these items will increase your page size and therefore its download time. Consider fetching items asynchronously, so the dropdownlist loads in the background but the user can still use the page.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush