Jeff wrote:
> -------- Original Message --------
> Subject: Re:Apache::DProf missing some subroutines
> From: Geoffrey Young <[EMAIL PROTECTED]>
> CC: modperl <modperl@perl.apache.org>
> 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

Reply via email to