Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

NYTProf and wait time

by ibm1620 (Monk)
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2018-06-20 12:16 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (116 votes). Check out past polls.