Quote:
Originally posted by george5006
A related question to my previous post, does anybody had any information about the relative performance of MyISAM vs. INNODB tables in MySQL?
To further clarify this, since INNODB is transactional, and MyISAM is not, it is probably safe to assume that the performance of MyISAM is better on WRIGHT operations. I am curious about the relative performance of the two table types on READ operations.
|
Depends on what do you really need.
If you need referential integrity and many features of transactional db then choose INNODB.
If you need high performance for write operations choose MyISAM.
There is not big difference in speed of select queries between MyISAM and INNODB.