MySQL Forums
Forum List  »  Partitioning

Re: Is partitioning helpful in this case?
Posted by: Shantanu Oak
Date: June 28, 2011 12:01AM

>> Is it a good idea to add an additional datetime field to the table and create a trigger to convert the timestamp to a datetime value when the row is added?

No. Infact it is a very bad idea.

You can use partitions even if you save a unix timestamp to the database instead of a datetime value. The only precaution needs to be taken is to write a correct select query that will take advantage of partitions.

Options: ReplyQuote

Written By
Re: Is partitioning helpful in this case?
June 28, 2011 12:01AM

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.