MySQL Forums
Forum List  »  Optimizer & Parser

Re: datetime vs date,time
Posted by: Alberto González
Date: May 17, 2007 10:08AM

KimSeong Loh Wrote:
-------------------------------------------------------
> Date is 3 bytes.
> Time is 3 bytes.
> Datetime is 8 bytes.
>
> The smaller size could have reduce the disk io and
> the amount of memory required to do sorting.
>
> Did you wrongly use order by field2,field2 desc?
> field2 twice?
yes mistake typing, order by field1,field2

Options: ReplyQuote


Subject
Views
Written By
Posted
9067
May 16, 2007 02:31AM
3526
May 17, 2007 05:07AM
3043
May 17, 2007 06:08AM
Re: datetime vs date,time
2936
May 17, 2007 10:08AM


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.