Re: Access speed INNODB VS. MyISAM

2006-06-04 Thread Ware Adams
On Jun 3, 2006, at 7:54 PM, Richard wrote: 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

Access speed INNODB VS. MyISAM

2006-06-03 Thread Richard
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