MySQL Forums
Forum List  »  Partitioning

Re: partitioning
Posted by: Rick James
Date: November 20, 2009 07:47PM

* Shoveling the 50M rows into the table will take time.

* Why did you decide to use Partition?

* Can you live without FOREIGN KEYs?

* If you need to SELECT by either week or month, you should consider partitioning by DAY.

Options: ReplyQuote


Subject
Views
Written By
Posted
3660
November 19, 2009 12:39AM
2338
November 20, 2009 05:01AM
Re: partitioning
2190
November 20, 2009 07:47PM


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.