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@pm.org http://mail.pm.org/mailman/listinfo/omaha-pm