Jump to content

Prestashop performance MyISAM Vs InnoDB


miracle
 Share

Recommended Posts

Hi,

MyISAM tables are far more faster than InnoDB for read only queries.

but for intensive writes operation it is preferable to use InnoDB which use row level locking for write operation (MyISAM uses table level locking).

So my suggestion (I do not test anything) is to use InnoDB for "statistics" tables like ps_connections_source.

Any comments ? Any cons&pros;about using innoDB tables?

Regards

Share this post


Link to post
Share on other sites

  • 1 month later...

Harcier,

You are correct that MyISAM tables are faster than compared to InnoDB and I won't get into the technical reasons why.

However, if you want the database to handle Foreign Key constraints automatically that functionality will only work with an InnoDB configuration.

So it is not always appropriate to use MyISAM in all tables.

You COULD write the code to handle it foreign keys yourself but since InnoDB does this for you and has been time tested the tradeoff is in speed.

Share this post


Link to post
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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More