Home All Groups Group Topic Archive Search About
Author
26 Feb 2006 3:23 PM
James T.
Hello!

Let's say I have 2 functions, both return data from the database. Now I
would like to compare perfomance of these two functions. Ex. I would like to
know how long it takes to execute these functions.

How can I do that?

Thank you!
James

Author
26 Feb 2006 3:53 PM
Cor Ligthert [MVP]
James,

If it is using version 2003 you can set the start-time by
enverironment.tickcount

If it is using version 2005 you can use the stopwatch.

http://msdn2.microsoft.com/en-us/library/system.diagnostics.stopwatch.aspx

I hope this helps,

Cor
Author
26 Feb 2006 6:11 PM
Terry Burns
Hi Cor,

How you doing ?, did you have a look over the code I sent you , any use to
you ?

--
Terry Burns
http://TrainingOn.net


Show quoteHide quote
"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:%23ht7SyuOGHA.3360@TK2MSFTNGP09.phx.gbl...
> James,
>
> If it is using version 2003 you can set the start-time by
> enverironment.tickcount
>
> If it is using version 2005 you can use the stopwatch.
>
> http://msdn2.microsoft.com/en-us/library/system.diagnostics.stopwatch.aspx
>
> I hope this helps,
>
> Cor
>
Author
26 Feb 2006 6:47 PM
Cor Ligthert [MVP]
> Hi Cor,
>
> How you doing ?, did you have a look over the code I sent you , any use to
> you ?
>
> --
Not yet, is a part in future. Is nicely saved.

Cor
Author
26 Feb 2006 6:53 PM
Cor Ligthert [MVP]
Terry,

I forgot to thank you for it, sorry, thanks,

Cor
Author
26 Feb 2006 7:49 PM
Terry Burns
No problem Cor. You are more than welcome.

--
Terry Burns
http://TrainingOn.net
Show quoteHide quote
"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:%23NBvtWwOGHA.2668@tk2msftngp13.phx.gbl...
> Terry,
>
> I forgot to thank you for it, sorry, thanks,
>
> Cor
>