MySQL Forums
Forum List  »  Newbie

Re: When to use Merge? :)
Posted by: Christian Hamel
Date: July 26, 2005 06:03AM

I guess a good example would be like in my company (But you don't use MySQL .... yet ;) )
We have a huge number of Sales transactions. These transactions never change, once created, that's it, they stay there. So at the end of each year, we could move a complete set of statistics for the previous year into it's own table.
With a Merge table then we could join
Sales1995
Sales1996
....
Sales2005

Since people don't do any reporting or on a very rare basis, I guess it could give a faster response time from MySQL to return a resultset for queries asking only for recent data.

As for the snippet of code, I would recommend the online manual, it's pretty well defined.
http://dev.mysql.com/doc/mysql/en/storage-engines.html

Options: ReplyQuote


Subject
Written By
Posted
July 25, 2005 04:29PM
Re: When to use Merge? :)
July 26, 2005 06:03AM


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.