MySQL Forums
Forum List  »  Newbie

Re: DATETIME vs. INT(11)?
Posted by: Rick James
Date: August 17, 2009 08:04PM

Lots of rows --> lots of time to execute. Especially if it has to hit the disk.

Functions or no functions -- this is relatively insignificant in performance issues.

Consider building a summary table indexed by year+month.

Options: ReplyQuote

Written By
August 14, 2009 10:00AM
August 15, 2009 03:26PM
August 17, 2009 10:31AM
Re: DATETIME vs. INT(11)?
August 17, 2009 08:04PM
August 26, 2009 09:23AM
August 26, 2009 11:30AM
August 26, 2009 11:55AM
August 26, 2009 11:34PM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.