Re: MyIsam vs Innodb Query Performance
Posted by:
Jay Pipes
Date: July 29, 2005 03:34PM
I would as well. Sometimes, however, you will find this situation. The clustered architecture of InnoDB sometimes lends itself nicely to large range and grouped expressions, because MyISAM must do considerable work in bookmark lookups when the temporary set of rows found is large. In that case, having the data in the index record can save quite a bit of processing time.
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
6552
July 29, 2005 05:29AM
2618
July 29, 2005 06:58AM
Re: MyIsam vs Innodb Query Performance
2595
July 29, 2005 03:34PM
2020
August 03, 2005 03:36AM
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.