Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

NYTProf and wait time

by ibm1620 (Scribe)
on Sep 19, 2012 at 17:15 UTC ( #994484=perlquestion: print w/replies, xml ) Need Help??
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

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.

      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!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://994484]
Front-paged by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (13)
As of 2016-09-26 13:59 GMT
Find Nodes?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:

    Results (479 votes). Check out past polls.