MySQL Forums
Forum List  »  Merge Storage Engine

Merge vs. UNION ALL
Posted by: James McKelvey
Date: April 05, 2011 10:33AM

Suppose that instead of using the MERGE engine I instead modified my code to UNION ALL the shards.

Would I get worse performance? In other words, besides the convenience, does the MERGE engine have specific performance optimizations that make it perform better?

This is of interest for several reasons. First, my code could determine in some cases that only a few (or a single) shards were needed. Second, I could apply the shard technique to InnoDB tables. Third, I could apply the shard technique to databases that were not identical.

Options: ReplyQuote

Written By
Merge vs. UNION ALL
April 05, 2011 10:33AM

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.