Performance measurements

Joel Peshkin bugreport at
Wed Oct 23 23:47:58 UTC 2002

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?


More information about the developers mailing list