MySQL Forums
Forum List  »  Partitioning

Re: No other way than delete primary key to create partitions by single datetime columns?
Posted by: Sam Young
Date: August 26, 2015 12:53AM

Enlightening article in the blog.
Partition seems not so powerful as in my guess.
Sorry for my lack of experience, if a table comes 10M+, 100M+ rows and more, what to do in general to keep the SQL's performance and avoiding entangle the service logic so mush?
split the table? use other DB product? or some nosql things? search engine?

Options: ReplyQuote

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.