core error

MyISAM vs InnoDB

Posted on: 13/07/2011


MySQL may work with 2 different storage engines. Which one is better? depends on the needs your application has.

Advantages of InnoDB (by default in MySQL)

  • ensures the integrity of the data in our tables (atomicity)
  • if our application does many INSERTs and UPDATEs, the performance will improve

Advantages of MyISAM

  • Much faster in SELECTs

So, if our table is quite dynamic we would need a lot of INSERTs and UPDATES and therefore we will need to work with InnoDB. In case a table is meant to be a source of data mainly, we will need to use MyISAM

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


    • Justin Cooney: Great comic, this made me laugh!
    • Justin Cooney: Interesting, I didn't know about the Google App Engine, I'm glad I found your article on it!

    Categories

    %d bloggers like this: