MySQL Forums
Forum List  »  Partitioning

Re: How should I partition this table?
Posted by: Ron Bergin
Date: May 03, 2013 09:32AM

Everything you're saying makes sense and I appreciate the input. I'll be sending you the sample selects after making this post.

I discovered that their queries were, as I suspected, more complex than the developers lead me to believe.

I have not yet implemented your prior suggestions, but I will. Prior to those latest recommendations of yours, I started the process of altering the partitions on the largest table (i.e., INVITMD) on the test server. I then ran a test using one of the sample queries that I'll be sending you. It took just over 16 seconds on the production box and less than 1 second on the test box. Part of the difference in results is due to better system specs on the test box, but I think the majority of it was due to the partitioning.

Options: ReplyQuote

Written By
April 26, 2013 09:18AM
Re: How should I partition this table?
May 03, 2013 09:32AM

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.