MyISAM and InnoDB - What is faster for reading and what for writing?

Question

MySQL

At least in theory / based on experience / benchmarks. Or does it depend on a whole bunch of nuances?

Answer 1

The engines are completely different and you need to use them in different situations.
To choose, you need to at least determine what will be more?
MyISAM locks the entire table when data is changed, while any SELECT will wait for the operation to be completed. InnodDB uses the line lock method.
Those. if there are more inserts, then InnodDB wins due to row locking (google InnoDB MVCC) if there are more fetches, then MyISAM can use the query cache and there will be a noticeable gain.
This is only part of the nuances, you should also remember about the settings of MySQL itself.

Answer 2

It all depends on the nuances.
If there is only one client, and in earlier versions, then reading / writing is faster in MyISAM
If there are many clients writing, then InnoDB is faster

Answer 3

postgresql
But seriously, then:
Something like that.