Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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 examining the Monastery: (6)
As of 2014-10-25 20:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (148 votes), past polls