http://qs321.pair.com?node_id=101876


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.