Benchmark code

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Mon, 21 Feb 2000 17:32:08 GMT
Message-ID: <1105_951154328@way>

I'm ashamed of myself, I'm sure it is written somewhere and I missed it completely ...

How do I time a statement? I mean If I want to try out the performance of two different ways to do something how should I measure them?

If I use the wallclock time I do not get anything realy useable since it depends not only on those statements, but also the server load at the time. I might run both versions several times intermixed and average them but it doesn't seem right anyway.

And if you want to compare the difference made by an index or whatever it's next to unusable.

So is there any way to get the time the server spent on some statement ?

Thanks, Jenda
http://Jenda.Krynicky.cz

P.S.: A CC: will be appreciated. Received on Mon Feb 21 2000 - 11:32:08 CST