Partitioning or Merge Storage Engine.

[nick]

Hi,

Please forgive me for being fairly new to this topic :)

I am fairly confused as to why one would want to use the merged storage
engine over partitioning? I played with the merged storage engine a while ago
and found a few limitations to it for my application, so gave up and sought other
solutions.

Partitioning looks great - is this going to be a replacement for merged
tables? If not, how should we decide which is best to use?

Thanks,
Nick