Tag Info

New answers tagged


To add to the responses here covering the mechanical differences between the two engines, I present an empirical speed comparison study. In terms of pure speed, it is not always the case that MyISAM is faster than InnoDB but in my experience it tends to be faster for PURE READ working environments by a factor of about 2.0-2.5 times. Clearly this isn't ...


"Compressed MyISAM" -- what is that? Maybe "Archive"? Compression is not needed; the tables are too small, and will quickly be fully cached. FOREIGN KEYS -- Why? You have debugged you code, haven't you? There will be no dangling things to check. MEMORY is not unreasonable, if you write 'reload' code that executes whenever you bring up the server, and any ...

Top 50 recent answers are included