Jeff wrote:
> -------- Original Message --------
> Subject: Re:Apache::DProf missing some subroutines
> From: Geoffrey Young <[EMAIL PROTECTED]>
> CC: modperl <[email protected]>
> Date: 11 May 2007 14:11:14
>
>>
>>> Also, Devel::Profiler can't handle many of the DBI implementations (you
>>> have to bad_pkgs=>[] them.
>>
>>
>> I don't have any trouble with core DBI or DBD::mysql or DBD::Oracle.
>> but there are lots of DBI-esque packages out there so I'll believe you.
>> in general Devel::Profiler doesn't like overloaded things.
>>
>
> interesting - DBD::mysql is the one that I reported a problem with a few
> years ago:
>
> http://groups.google.co.uk/group/perl.perl5.porters/browse_thread/thread/29602d15e7586b79/a11948e8b7854a4b
current svn given me this on our codebase:
0.67 0.056 0.056 780 0.0001 0.0001 DBD::mysql::st::fetch
0.65 0.054 0.117 480 0.0001 0.0002 DBD::_::db::prepare_cached
0.46 0.038 0.038 480 0.0001 0.0001 DBI::db::prepare_cached
0.44 0.037 0.037 480 0.0001 0.0001 DBI::st::execute
0.34 0.028 0.028 480 0.0001 0.0001 DBI::st::bind_columns
0.23 0.019 0.019 220 0.0001 0.0001 DBD::mysql::db::ping
0.23 0.019 0.019 220 0.0001 0.0001 DBI::db::do
0.23 0.019 0.019 480 0.0000 0.0000 DBD::mysql::st::execute
0.22 0.018 0.018 220 0.0001 0.0001 DBI::db::ping
0.22 0.018 0.018 700 0.0000 0.0000 DBI::db::FETCH
0.22 0.018 0.018 500 0.0000 0.0000 DBI::st::FETCH
0.22 0.018 0.018 480 0.0000 0.0000 DBD::mysql::st::FETCH
0.22 0.018 0.018 440 0.0000 0.0000 DBD::mysql::st::finish
0.11 0.009 0.009 700 0.0000 0.0000 DBD::mysql::db::FETCH
0.11 0.009 0.009 480 0.0000 0.0000 DBD::_::st::bind_columns
0.11 0.009 0.009 780 0.0000 0.0000 DBI::st::fetch
0.11 0.009 0.009 440 0.0000 0.0000 DBI::st::finish
which looks reasonable enough to me :) you might want to give svn a
try. also, our bad_pkgs looks like
bad_pkgs => [qw( UNIVERSAL Time::HiRes B Carp
Exporter Cwd Config CORE DynaLoader XSLoader
AutoLoader utf8 )],
in case any of those are the ones causing trouble for you.
>
>> you might also try the latest from svn to see if that works better for
>> you:
>> http://sourceforge.net/projects/devel-profiler/
>
>
> I have the last released => v0.04, June 9 2002, but I see that there was
> a not-yet-released change in 2003 for autoloaded. Might just wait until
> an 0.05 is floated - we can always blame the database for performance
> issues in the mean time :)
there's no timeframe for 0.05 at this point, but I suspect svn looks
like 0.05 will with the exception of some additional documentation updates.
HTH
--Geoff
