Should I convert this to INNODB ?

[Charl Gerber]

Hi,

I have a database with relatively small tables. Ie, for permorfance, MyISAM would probably be better. However, the tables are quite dynamic and I could very well use foreign keys.

For example, I have a "users" table and a "messages" table with a foreign key to the users to indicate the message owner.

In MyISAM, if I delete a user, I have to DELETE from USER and then also DELETE FROM messages WHERE user=xxx.

Would this be far more efficient to convert to INNODB and let the FOREIGN KEY and ON DELETE CASCADE ... take care of this sort of thing? Certainly my (java) code would me neater and I like the idea of splitting the DB related logic and keep it seperate from the java code and logic.

I'm also working in a highly concurrent system, so the row locking of the INNODB migth be handy.

Comments or suggestions?