We don't bite newbies here... much | |
PerlMonks |
Profiling and Performanceby Herkum (Parson) |
on Mar 26, 2009 at 23:01 UTC ( [id://753539]=perlquestion: print w/replies, xml ) | Need Help?? |
Herkum has asked for the wisdom of the Perl Monks concerning the following question: I was working on some code and decided to give Memoize a shot since I had run out of ideas of how to make my application faster and was using Devel::Prof to help identify problem areas. The results were great, was I able to get it to run about 6 times faster than before!I was very happy however the last part I am having problems with is having to do with database queries. Devel::Prof tells me what methods are taking my time and how many calls there are but it does not tell me where those calls are coming from. In this case, it is telling me that the database queries are taking most of the time now but not which ones. See below...
The two things I would like to tackle are the number of calls to are being made to refaddr(which is being called from Class::Std ident function). Is there some what I can override the exported ident? The second is tracing where the SQL calls that are being made for DBI::db::do and DBI::db::execute. Help? Suggestions?
Back to
Seekers of Perl Wisdom
|
|