I have been using a database for several years that uses many 'lookup' style
tables. i.e. no updates to these tables. I dumped the whole thing into an INNODB
database for simplicity, but I now wonder if I can speed things up if I put only
my updatable tables in INNODB (I need row level locking for these) and put all
the lookup tables in MyISAM.
The benchmarks I have looked at don't seem to reveal either as a clear winner,
but I am probably not interpreting them properly.
Thanks for much in advance for any help on this question.