Ndtyjky

As part of my Application Architecture Module at Uni I am testing the time taken to retrieve data from an MS SQL server local and remotely. I have a user interface using visual studio 2017 ASP.NET with c#. I instantiate and start a stopwatch control when a user clicks a button and stop the stopwatch when afer the line of code that bind the result to the gridview. I have two buttons, one runs the code to a local databaase created in visual studio and the other button runs identical code (except connectionstring) to remote SQL Server (GoDaddy). The results i am getting are very fast 30ms and 100ms remotely.

My question really is, are the times i am getting accurate for what i think its doing or it just giving me the time to create the page after postback.

Is there i way i can simulate simultaneous connections to each database to test performance under real world use.

    protected void Btnlocal_Click(object sender, EventArgs e)

    {

        if (txthouseno.Text != "" && txtpostcode.Text != "")

        {

            Label4.Visible = true;

            Stopwatch localStopWatch = new Stopwatch();

            localStopWatch.Start();



            string connectionString;

            SqlConnection cnn;

            connectionString = @"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=C:xxxxxxxxxxxxxxxx.mdf;Integrated Security=True;Connect Timeout=30";

            cnn = new SqlConnection(connectionString);

            cnn.Open();

            lbllocal.Text = "Local Database Connected";

            SqlCommand command;

            SqlDataReader dataReader;



            String sql = "select * from Customer where postcode = @custpcode AND houseno = @custhouseno";

            command = new SqlCommand(sql, cnn);



            var custpostParam = new SqlParameter("custpcode", SqlDbType.VarChar);

            custpostParam.Value = txtpostcode.Text;



            var custhouseParam = new SqlParameter("custhouseno", SqlDbType.VarChar);

            custhouseParam.Value = txthouseno.Text;



            command.Parameters.Add(custpostParam);

            command.Parameters.Add(custhouseParam);

            dataReader = command.ExecuteReader();

            GridView1.DataSource = dataReader;

            GridView1.DataBind();

            localStopWatch.Stop();

            command.Dispose();

            cnn.Close();

            connectionString = "";



            lbllocal.Text = "Local PC Time Taken = " + localStopWatch.ElapsedMilliseconds.ToString() + " ms";



        }

    }



    protected void Btnremote_Click(object sender, EventArgs e)

    {          

        if (txthouseno.Text != "" && txtpostcode.Text != "")

        {

            Label5.Visible = true;

            Stopwatch remoteStopWatch = new Stopwatch();

            remoteStopWatch.Start();

            ViewState["pageLoadTime"] = DateTime.Now;

            string connectionString;

            SqlConnection cnn;

            connectionString = @"Data Source=xxx.xxx.xx.xxx;Integrated Security=False;User ID=xxxxxx; Password = xxxxxx; Connect Timeout=15;Encrypt=False;Packet Size=4096";

            cnn = new SqlConnection(connectionString);

            cnn.Open();

            SqlCommand command;

            SqlDataReader dataReader;



            String sql = "select * from dbo.Customer where postcode = @custpcode AND houseno = @custhouseno";

            command = new SqlCommand(sql, cnn);



            var custpostParam = new SqlParameter("custpcode", SqlDbType.VarChar);

            custpostParam.Value = txtpostcode.Text;



            var custhouseParam = new SqlParameter("custhouseno", SqlDbType.VarChar);

            custhouseParam.Value = txthouseno.Text;



            command.Parameters.Add(custpostParam);

            command.Parameters.Add(custhouseParam);

            dataReader = command.ExecuteReader();

            GridView2.DataSource = dataReader;

            GridView2.DataBind();

            remoteStopWatch.Stop();

            command.Dispose();

            cnn.Close();

            connectionString = "";



            lblremote.Text = "Remote Server Time Taken = " + remoteStopWatch.ElapsedMilliseconds.ToString() + " ms";



        }

    }    enter code here