There's more than one way to do things | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
In my CGI::Application I use DBI - connecting to the database as it starts, disconnecting at the end. During the course of the different run modes a different number of SQL queries are executed. Is it possible to have a count of the "number of queries" executed in some simple manner? Right now the only approach seems to be to subclass DBI, and have a counter which is incremented in 'execute' or 'query' methods, is that correct? (I'm looking to have something which I've seen a lot of PHP applications do; show at the bottom of the page "Generation took xx queries and xx seconds". This will also help me keep track of potential database slowpoints). In reply to DBI query count? by skx
|
|