Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    9

    Unanswered: MyISAM v/s INNODB

    Hi

    Which table type would be better for better performance on reads? INNO DB provides transaction support and use more storage space plus extra overheads when writes happen but does anyone have any idea as to the performance comparisons when it comes to reads only?

    thanks
    --Hitesh

  2. #2
    Join Date
    Jun 2003
    Posts
    21

    Re: MyISAM v/s INNODB

    Originally posted by hitesh2512
    Hi

    Which table type would be better for better performance on reads? INNO DB provides transaction support and use more storage space plus extra overheads when writes happen but does anyone have any idea as to the performance comparisons when it comes to reads only?

    thanks
    --Hitesh
    Why use innoDB when most of what you want to do is reading from your DB. I guess InnoDB would be slower because of the fact that it needs to read data from a bigger file then does MyISAM. But that's only a guess.

    Niels

  3. #3
    Join Date
    Jun 2003
    Posts
    9

    Re: MyISAM v/s INNODB

    INNODB uses a clustered index on the primary key and tends to store the record in the same page as the primary key. This tends to improve its performance to MyISAM when selecting based on the primary key. (as MyISAM requires a jump to the record page after finding the primary key index).

    However want I wanted to know was how much of a performance variation would be there if there were we were selecting on a secondary index or no index at all.

    (In case of writes MyISAM is faster but INNODB provides version support, transactions etc.)

    thanks
    --Hitesh

Posting Permissions

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