On Sun, Jul 22, 2012 at 3:36 PM, Alex <amea...@gmail.com> wrote: > > The searches are within the database yes, the problem is that "not much of a > performance hit" isn't ideal when carrying out a large number of searches.
I've just had a look around online. Various test results may surprise you. http://dbscience.blogspot.ca/2008/08/can-timestamp-be-slower-than-datetime.html http://www.dbtuna.com/article.php?id=36 http://gpshumano.blogs.dri.pt/2009/07/06/mysql-datetime-vs-timestamp-vs-int-performance-and-benchmarking-with-myisam/ I suggest you conduct your own tests before trying to modify Cake's internals. > Converting it after performing the search wouldn't help the performance of > the search unfortunately. That suggestion was for the case where many date comparisons were being done in your application code, not the DB queries. > Sorry by usually I'm referring to US/UK, I have a slight bias :) Sure, but my point is that those other formats are not at all a good choice for programming. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
