MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


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


Sorry, you can't reply to this topic. It has been closed.

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.