Re: Performance
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.
Subject
Views
Written By
Posted
3646
July 05, 2006 12:21PM
1677
July 05, 2006 05:42PM
1633
July 06, 2006 09:16AM
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.