Performance measurements

[Bradley Baetz]

On Wed, 23 Oct 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? 

When you run teh query from mysql it shows the time taken at the end :)

I have a script to generate n bugs; I'll tidy it up and attach it this 
evening.

> How do you time the execution of a CGI script in a webserver? 

The best way is to  time it from teh cmd line, redirecting to /dev/null, 
so:

time REQUEST_METHOD=GET QUERY_STRING="foo=bar&bar=1" perl -wT foo.cgi > /dev/null

> What's the Perl profiler called, if there is one, and where can I find 
> out about it?

perldoc DProf.

dprofpp -S is often useful

Note that occasionally running with -d:DProf segfaults on me; running it
again fixes it. Thats a perl bug which I haven't managed to track 
down/report/etc.

> That sort of stuff... :-)
> 
> Gerv

Bradley