NYTProf and wait time

ibm1620 has asked for the wisdom of the Perl Monks concerning the following question:

I'm using NYTProf for the first time and I see that 89% of my time is spent in DBI::st::execute. NYTProf doesn't show me any of that source, nor does it indicate how much of that is CPU versus I/O wait.

I've looked in the CPAN doc for an answer, without success.

Is this info (primarily, wait vs. CPU) available from the HTML report? And is there a way to see further into the modules; e.g. DBI/DBD?

Thanks, Chap

Comment on NYTProf and wait time

Replies are listed 'Best First'.
Re: NYTProf and wait time by mje (Curate) on Sep 19, 2012 at 18:46 UTC
With most DBDs (you did not mention which you are using) the DBI::st::execute method will not be Perl code. It will most probably be XS (C code) and D::N does not profile C code. This applies to any XS module methods, not just DBI.	[reply]
Re^2: NYTProf and wait time by ibm1620 (Hermit) on Sep 19, 2012 at 22:55 UTC
It's DBD::mysql. The CPAN page doesn't mention if it's XS or not, but I'd guess it probably is; if so, I can understand why it cannot be profiled. Thanks!	[reply]
Re^3: NYTProf and wait time by mje (Curate) on Sep 20, 2012 at 07:43 UTC
If you want to profile the SQL statements taking time in the execute you should look at DBI profiling http://search.cpan.org/~timb/DBI-1.622/lib/DBI/Profile.pm and the Profile attribute in DBI.	[reply]