> I know the major differences between Innodb and MyIsam.
> -table locking versus row locks
> -foreign key support
> I know there are more but those are the ones that stick out in mind.
Well, how about "transaction support"?
> I think Innodb requires a bit more storage space but I could be wrong.
> In some cases foreign key support would be a nice thing. So my questions
> What is the ultimate criteria for choosing Innodb. And, if I just want it
because I like to have the luxary of foreign key / cascading etc, is that
reason enough to use them.
Foreign keys "luxury"? Well, if this aint a read-only database,
I wouldn't call that a luxury, but rather a requirement.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL