I also suspect that you didn't initialize the debugger before compiling your code, since none of your code appears in this output.

I got the previous output because I put in the debugger initialization...

Without initialization (Apache::DB->init), this is the top 5 output before the cache is filled (with dprofpp -r):

Exclusive Times
%Time ExclSec CumulS #Calls sec/call Csec/c  Name
33.5   23.74  5.224      1   23.747 5.2236  ELRes::ApacheHandler::handler
1.09   0.772  0.772   7869   0.0001 0.0001  Storable::mretrieve
0.87   0.615  0.615   1418   0.0004 0.0004  Storable::net_mstore
0.70   0.495  0.495   1524   0.0003 0.0003  DBD::mysql::db::_login
0.54   0.380  0.380   2902   0.0001 0.0001  DBI::_new_sth
0.51   0.359  0.388   8852   0.0000 0.0000  DBI::common::DESTROY

and this one is after it's filled:

Exclusive Times
%Time ExclSec CumulS #Calls sec/call Csec/c  Name
16.5   13.85 14.780      1   13.857 14.780  ELRes::ApacheHandler::handler
0.21   0.174  0.174  34766   0.0000 0.0000  Date::Simple::DESTROY
0.20   0.170  0.170   6580   0.0000 0.0000  Storable::mretrieve
0.19   0.162  0.162  99576   0.0000 0.0000  Date::Simple::as_iso
0.14   0.115  0.115  27854   0.0000 0.0000  Date::Simple::_add
0.11   0.090  0.090     25   0.0036 0.0036  DBD::mysql::db::_login

How should I interpret these outputs and what should I do about it to improve my app's speed? This is the first time for me to optimize a large perl codebase... So I need a bit of guidance here...

Thanks a lot...

---
Badai Aqrandista
Cheepy (?)

_________________________________________________________________
Your opinion counts..for your chance to win a Mini Cooper click here http://www.qualifiedopinions.com/joinup.php?source=hotmail

Reply via email to