Quote:
|
Originally Posted by goBigtime
Last time I checked...
INNODB = faster reads (use for read-heavy tables)
InnoDB = faster writes (use for write-heavy tables)
Maybe it's different now?... I initially got this information from a guy running one of the largest forums on the net. That was basically his nutshell response. He does use InnoDB, but only for write-heavy tables. The guy has a cluster of like... 40 servers or something.
|
From my experience with it, I've found that for selects, InnoDB is faster when the table in question is larger and is written to often. When the table is smaller or not frequently modified, then myisam is faster. Ofcourse InnoDB has other advantages like recovery features, transaction support, etc...
Right now though we're checking out NDB type for use with MySQL Cluster.....hopefully it outperforms all the other types by leaps and bounds
