Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: MyISAM vs. INNODB

    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.

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: MyISAM vs. INNODB

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •