MySQL Forums
Forum List  »  Performance

Re: Challenging performance demand
Posted by: Shane Bester
Date: July 13, 2005 07:54AM

What is stored in `lastupdated` char(10) ??
Perhaps you can change it to a DATETIME or even DATE field to make it smaller?
Here are the sizes of these datatypes:

DATE=3 bytes
DATETIME=8 bytes
TIMESTAMP=4 bytes
TIME=3 bytes

Options: ReplyQuote


Subject
Views
Written By
Posted
2707
June 02, 2005 03:16PM
1823
June 03, 2005 07:10AM
Re: Challenging performance demand
1860
July 13, 2005 07:54AM
1760
July 13, 2005 10:10AM
1785
July 14, 2005 10:02AM
1888
July 14, 2005 12:03PM
1797
July 17, 2005 03:07AM


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.