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