3 ms·
MyISAM was historically notably faster for simple SELECTs on the primary key and SELECT COUNT(*). InnoDB had ranged from slightly faster to much slower than P
by acdha 6y ago
MyISAM was historically notably faster for simple SELECTs on the primary key and SELECT COUNT(*).
InnoDB had ranged from slightly faster to much slower than Postgres depending on exactly what you’re doing. Once you’re doing more than trivial queries the MySQL optimizer tends to fall apart, often in weird ways with arbitrary thresholds where performance goes from decent to terrible after a table grows by 5%.