MySQL Forums
Forum List  »  MyISAM

Re: Performance
Posted by: Ingo Strüwing
Date: July 19, 2006 01:27AM

A view would not help as it does an SQL select implicitly.

A separate table with much less rows would help.

You may want to look at MERGE tables for the FILO strategy. A MERGE table combines multiple MyISAM tables. It is easy to add a new MyISAM table every 14 days and remove the oldest, if necessary. Inserts can go to the last table only, but selects go over all MyISAM tables. You can also access the MyISAM tables independently, that is you could read the last table only. You can even have multiple MERGE tables on top of the MyISAM tables if you like to access the last two or three tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
3646
July 05, 2006 12:21PM
1831
July 14, 2006 12:07PM
Re: Performance
1625
July 19, 2006 01:27AM


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.