Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Benchmarking A DB-Intensive Script

by rnahi (Curate)
on Mar 14, 2006 at 07:37 UTC ( #536490=note: print w/ replies, xml ) Need Help??


in reply to Benchmarking A DB-Intensive Script

Using Devel::Dprof and dprofpp, which are part of recent Perl distributions, you should find out where your code is slow.

Regarding the database issues, DBI::Profile can find which methods are taking too long (you can look at Speeding up the DBI for suitable examples and tips).


Comment on Re: Benchmarking A DB-Intensive Script
Replies are listed 'Best First'.
Re^2: Benchmarking A DB-Intensive Script
by perrin (Chancellor) on Mar 14, 2006 at 15:24 UTC
    And when you use Devel::DProf, tell it to report wall time, so you can see the time spent waiting for the database. Otherwise, it just measures CPU, and you get a strange picture in a database-heavy script.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://536490]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (12)
As of 2015-07-31 21:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (282 votes), past polls