hi there,

would anyone know how to spit out the time it took for a page to run a store procedure from mysql???

basically this is for troubleshooting, so when a page loads and bind data to gridsview, formview..etc...

i want to have couple of labels somewhere on the page to display how long did it took the page to load and the store procedure to run

hope someone has sample they could share

cheers

You can time most things like this:

    protected void Button1_Click(object sender, EventArgs e)
    {
        System.Diagnostics.Stopwatch Timer = new Stopwatch();

        Timer.Start();

        // do the task
        Thread.Sleep(1000);

        Timer.Stop();

        Label1.Text = Timer.Elapsed.TotalSeconds.ToString("N2");

 what is "N2"?

  Label1.Text = Timer.Elapsed.TotalSeconds.ToString("N2");

TotalSeconds is type Double (a floating point type).

N2 formats the number to two decimal places:

1   :   1.00

2.3  :  2.30

1.234 : 1.23

Thanks Steve for explaining about "TotalSeconds N2". It took me all day to find out how to round "TotalSeconds" to 2 decimal places.

Your explanation is short and to the point, thanks...