> 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
are:
> 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.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
