Re: 39 MILLION ROW MARCH (USING MyISAM)
Posted by:
James Day
Date: November 22, 2005 10:22PM
Interesting approach, but why not just use the InnoDB storage engine with the primary key/physical order set appropriately, then use "covering indexes" for time-critical queries? You can use covering indexes with MyISAM as well. A covering index is an index which contains every field used in the select.
Your data set seems fairly small, so you're unlikely to have great problems doing it that way.
If most queries are for only a few fields there is often benefit in moving the other fields into a table of their own, leaving just the commonly queried fields in the main table.
James Day
Support engineer, MySQL AB
Subject
Views
Written By
Posted
2641
November 03, 2005 07:05AM
1319
November 03, 2005 04:36PM
1427
November 16, 2005 05:26PM
1430
November 16, 2005 06:42PM
1422
November 16, 2005 06:51PM
1502
November 17, 2005 05:24PM
1366
November 16, 2005 07:35PM
1558
November 17, 2005 05:19PM
1300
November 17, 2005 06:38PM
1443
November 18, 2005 07:56PM
1392
November 29, 2005 12:48PM
1325
November 29, 2005 12:50PM
Re: 39 MILLION ROW MARCH (USING MyISAM)
1455
November 22, 2005 10:22PM
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.