MySQL Forums
Forum List  »  Newbie

Re: MySQL Partitioning showing low performance
Posted by: Manosh Manohar
Date: February 13, 2013 01:12AM

Thank You for the reply.

>SELECT column8, column9 FROM myTable WHERE column2 = ? AND column3 = ? AND column4 =? AND column5 = ? AND column7 = ? AND column6 = ? LIMIT 1;

As I said, the number of records currently in the database is about 342 million.

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?

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.