Jump to content

InnoDB for Image Gallery Tables


j.silver

Recommended Posts

Dear all,

 

For photo gallery tables (named: gallery_album, gallery_image, gallery_relation), I have seen a recommendation to use InnoDB engine in preference to MyISAM. I thought MyISAM would be the choice for all tables but tables for transactions. Do you agree with the recommendation to using InnoDB for photo gallery tables and why?

Link to comment
Share on other sites

InnoDB has a better reputation -- but do you really need to store the images in a database? If you don't need the images to be secure then you can simply store them in the filesystem.

Link to comment
Share on other sites

The fact that InnoDB supports transactions and foreign keys and MyISAM does not is enough for me to always use InnoDB. The table-level locking that MyISAM does has also brought applications to a halt, where many people are waiting to write to a particular table that one person is selecting data from even though they are working with different rows. MyISAM still locks the entire table.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...