Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

NYTProf and wait time

by ibm1620 (Beadle)
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

Comment on NYTProf and wait time
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (9)
As of 2014-11-28 09:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (194 votes), past polls