On Sat, 30 Jun 2001, Orlando Andico wrote:
..
> I have a major Perl program which does a lot of SQL queries. In the past I
> would time each query using Time::HiRes like this:
>
> $t0 = [gettimeofday];
> # do SQL query and stuff
> $t = [gettimeofday] - $t0;
> print "DEBUG: time elapsed is $t\n";
Nyark. Nevermind, I found the *perfect* solution: DBIx::Profile. It just
profiles the DBI/SQL calls, since the rest of the program is rate-limited
by how fast Oracle can give me back data.
DBIx::Profile is quite good. I enjoin all Perl/DBI users on the list to
give it a peek. Will save you lots of query-optimization
tearing-out-of-hair.
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GE d(-) s: a-25 C++++ UBLSI++++$ P+++ L+++>++++ E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
------END GEEK CODE BLOCK------
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
