Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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
[Lady_Aleena]: Lingua::EN:: Inflect now has a supposedly better sibling Lingua::EN:: Inflexion.

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (8)
As of 2017-05-24 18:04 GMT
Find Nodes?
    Voting Booth?