Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

INT vs. TIMESTAMP data types [message #2934] Fri, 11 April 2008 16:26  Speeple Messages: 91 Registered: August 2006 Member Hi, Currently for a blog platform I have: year=YEAR month=TINYINT day=TINYINT timestamp=INT I was contemplating using the TIMESTAMP type. To get previous usage like yearly monthly etc archives I would do: WHERE author=4 AND YEAR(timestamp)=2008 AND MONTH(timestamp)=4 Would this utilize an index on INDEX(author, timestamp) or would the functions YEAR() and MONTH() which extract kill the index usage? Cheers! Martin Gallagher | Speeple: The latest news Report message to a moderator

	INT vs. TIMESTAMP data types By: Speeple on Fri, 11 April 2008 16:26
	Re: INT vs. TIMESTAMP data types By: carpii on Fri, 11 April 2008 21:01
	Re: INT vs. TIMESTAMP data types By: Hubert Roksor on Sat, 12 April 2008 03:35
	Re: INT vs. TIMESTAMP data types By: Speeple on Sat, 12 April 2008 07:07

Previous Topic:	ndb size
Next Topic:	Tweak Innodb parameters

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]