Quote:
Originally Posted by Tempest
What are the benifits/drawbacks to InnoDb instead of INNODB?
I pretty much always use auto_increment primary key Ids in my tables.
|
For rows that change often or for big tables use InnoDB. For reference tables, that say have few rows that never change, choose INNODB.
Best you check mysql.com for full comparisons between all engine types though.