[Omaha.pm] Devel::Timer useful for MySQL performance tuning

[Mat Caughron]

Jay et al:

The MySQL TIMESTAMP doesn't really go beyond seconds (there are some hacks 
for milliseconds but that also isn't likely to be good enough)  which 
makes performance tuning with native SQL difficult at best.  So the next 
best thing would be to break complex queries into pieces and let your 
application handle high-res time resolution for each beginning and 
ending each piece.
    (  http://dev.mysql.com/doc/refman/5.0/en/time.html  )

Thanks for pointing this one out!



Mat Caughron




On Wed, 10 May 2006, Jay Hannah wrote:

> Ooo... I need one of these today. New toy!
>
> http://search.cpan.org/~jmoore/Devel-Timer-0.01/Timer.pm
>
> I love how every time I have a "wouldn't it be great if" idea someone
> has written it already and put it in CPAN.
>
> j
>
> _______________________________________________
> Omaha-pm mailing list
> Omaha-pm at pm.org
> http://mail.pm.org/mailman/listinfo/omaha-pm
>