Re: Change created/modified to unix time

On Sun, Jul 22, 2012 at 3:36 PM, Alex <amearns@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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php