Would it be possible to extract the profiling engine from DBI and make
it available to the calling application? Or to make it play nicely with
other run-time profiling modules (if there are any decent ones)? For
example, it would be nice to be able to have a mod_perl application be
able to collect performance information in a common format from database
queries, HTML template generation, and application code.
Some options for controlling the output would also be nice. I'd like to
be able to accumulate performance data over a series of queries and then
output a formatted report all at once. Maybe this sort of thing belongs
in add-on modules as you suggested.
Cheers,
-Jason
Tim Bunce wrote:
>Given this code:
>
> my $dbh = DBI->connect("dbi:ExampleP:", '', '', {
> Profile => 1 # <=== NEW
> });
> my $sth = $dbh->prepare("select mode,size,name from ?");
> $sth->execute(".");
> while ( my $hash = $sth->fetchrow_hashref ) {
> }
> exit 0;
>
>(rest deleted)
>
>
>
