MySQL Forums
Forum List  »  Newbie

Re: MySQL Partitioning showing low performance
Posted by: Rick James
Date: February 14, 2013 09:57PM

> Is there any record count till which doing partitioning could be useful for the above query? Or is it that partitioning is not a good idea at all for this specific query?

I have a Rule of Thumb: Do not partition a table unless it has at least a million rows.

But, that is not what you asked. I know of 3 uses for Partitioning. Only one of them speeds up by using PARTITIONs. That case involves 2-dimensional lookups.

Partitioning does not help that particular query, regardless of how many rows it returns.

Partitioning _may_ help some other query.

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.