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. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
