For the online store engine: InnoDB or MyISAM?
For the online store engine (php), which type of tables is better to do: InnoDB or MyISAM ?
What are the differences between these types?
How can you justify your choice?
4 answers
If such a question arises, it is better to take MyISAM: more tolerance for glitches and sloppy handling. InnoDB allows you to lock tables normally, it works a little faster. But in the event of a breakage of the table without a backup, it is almost impossible to restore it.
A store? Only InnoDB, because you'll probably need transactions.
Just configure the server correctly, so that "tolerance for glitches and sloppy handling" is not useful to you.
And better-take the same postgres.
Most likely, you will not feel the difference.
I wrote the article a long time ago, but nothing has changed fundamentally.
InnoDB. Because there are 2 big advantages:
- does not block the entire table but only one row (MyISAM blocks the entire table)
- you can build links