From: Jan Steinman Date: April 5 2010 2:25pm Subject: RE: MyISAM better than innodb for large files? List-Archive: http://lists.mysql.com/mysql/221142 Message-Id: MIME-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit > From: Gavin Towey > > InnoDB should be your default for all tables, unless you have > specific requirements that need myisam. One specific example of an > appropriate task for myisam is where you need very high insert > throughput, and you're not doing any updates/deletes concurrently. A couple other things: InnoDB does relations better, MyISAM does search of text fields. ---------------- If we can control fuel we can control the masses; if we can control food we can control individuals. -- Henry Kissinger :::: Jan Steinman, EcoReality Co-op ::::