how to find the execution time for 30 simulataneous users..

Question

0.00/5 (No votes)

See more:

I have a small windows application where the click on a button will display the list of users in a datagrid starting with a name that is entered in a textbox..

I would like to find out how much it takes if there are 30 users uses this search page simultaneously and find out the time it takes to fetch the results on to datagrid of my windows application..

sample code:

C#

private void btnseacrh_Click(object sender, EventArgs e)
  {
      var name=txttextbox.Text;

     var Resultdataset= Fecthresultfromdb(name);
     
 // retchresultfromdb method calls the database and fetches all the people whose name //starts with 'name' value entered in a textbox
     
    //finally result set is bind to datagrid for display

    datagrid.datasource=Resultdataset;

  }

Now I would like to know if there are 30 users concurrently using this seacrher window,how much time it takes..This is one of non functional requirement that has to be met within 3 secs.

PLease tell what modifications i need to do..PLease share the modified code snippet as well.

Posted 7-Jan-14 7:19am

mahesh kumar BM

Updated 7-Jan-14 7:27am

André Kraak

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ron Beyer · Accepted Answer · 2014-01-07T07:24:00

What you are asking about is called load testing. Depending on what Visual Studio version you are using, there are built-in tools to help you load test your application. See Visual Studio Load Testing Tools[^]

If you are using some other version that doesn't have those tools, you should look at third party load testing tools for .net[^].

Your other option is to create a unit test application and queue up 30 parallel tasks to hit the database at the same time and use performance counters to measure responses, but this takes a lot more set up than using load testing tools. Some of the ones in the google link may have trial versions that run for some number of days or number of concurrent tests, evaluate each one to find one that meets your needs.

[Edit]

Here is a sample, simple load test you can do:

C#

public class LoadTester
{

    List<TimeSpan> times = new List<TimeSpan>();

    public void Test()
    {
        Thread[] threads = new Thread[30];

        for (int i = 0; i < 30; i++)
        {
            threads[i] = new Thread(new ThreadStart(TestDBConn));
            threads[i].IsBackground = true;
            threads[i].Name = "Test Thread " + i.ToString();
        }

        for (int i = 0; i < 30; i++)
        {
            threads[i].Start();
        }

        bool allFinished = false;

        while (!allFinished)
        {
            allFinished = threads.All(t => t.ThreadState == System.Threading.ThreadState.Stopped);
            Thread.Sleep(10);
        }

        double minMs, maxMs, avgMs, sum;
        minMs = double.MaxValue;
        maxMs = double.MinValue;
        sum = 0.0;

        foreach (TimeSpan ts in times)
        {
            if (ts.TotalMilliseconds < minMs)
                minMs = ts.TotalMilliseconds;

            if (ts.TotalMilliseconds > maxMs)
                maxMs = ts.TotalMilliseconds;

            sum += ts.TotalMilliseconds;
        }

        avgMs = sum / (double)times.Count;

        System.Diagnostics.Debug.WriteLine("Max: " + maxMs);
        System.Diagnostics.Debug.WriteLine("Min: " + minMs);
        System.Diagnostics.Debug.WriteLine("Avg: " + avgMs);
    }

    public void TestDBConn()
    {
        Stopwatch sw = new Stopwatch();

        sw.Start();

        //Run your test here

        sw.Stop();

        times.Add(sw.Elapsed);
    }
}

You would put your call to Fecthresultfromdb(name) where it says "Run your test here". I would pull this function out of your form since you only care about the load on the database, the updating of the UI happens in a fixed time, regardless of the number of clients. Its the fetch from the database that will change.

Output will be in the output window.