Performance measurements

[Joel Peshkin]

Gervase Markham wrote:

> Can people please share with the list the tools they use to measure 
> Bugzilla performance? For example, does MySQL have a way to time a 
> query? How do you time the execution of a CGI script in a webserver? 
> What's the Perl profiler called, if there is one, and where can I find 
> out about it? That sort of stuff... :-)
>
> Gerv
>
OK -- time for me to confess....

I usually hack a chunk of code into sanitycheck.cgi that checks the 
time,  runs the query *many* times, then prints the time elapsed.  As 
long as I am checking one version of something agains another, it is not 
a bad way to test.   I rarely care about a 5% or 10% differrence, 
though.  Uusually, it is order-of-magnitude.

Perhaps we should add a mode to SendSQL that permits us to repeat 
non-destructive queries enough to get a reasonable average?

-Joel