MySQL Forums
Forum List  »  InnoDB

Should I convert this to INNODB ?
Posted by: Charl Gerber
Date: February 24, 2005 03:14AM


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?

Options: ReplyQuote

Written By
Should I convert this to INNODB ?
February 24, 2005 03:14AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.