in reply to Devel::Dprof is your friend
When we moved from DB_File type data storage to SQL backend, I was so sure that the sudden performance hit was because of a slow connection and the way I was fetching the data from the backend...
Then I was suggested to use Devel::Dprof and boy, turns out it was something totally different -- it was the fact that I was converting database time into epoch time
I ended up changing the entries in the database to epoch time, and the execution time was cut down to about 1/3 of what it used to be
Yes, Devel::Dprof rocks.
|
---|
In Section
Meditations