MySql - innodb or myisam?

**mikesolomon** · 2009-03-25, 10:27 PM

I am running on mysql

My databases are set up as innodb

Would I be better off with myisam?

**Angel** · 2009-03-25, 10:38 PM

SugarCRM On Demand runs off of InnoDB, so it should be safe.

**stevec** · 2009-03-26, 02:22 PM

It depends on the size of the database and the number of users. The more users, the better innodb suits the implementation as it has a more granular record locking when updating tables. It's also an 'ACID' database engine - so it shouldn't corrupt as easily as MyISAM could.

However, if it's a small dataset and only a couple of users, then MyISAM could be better as it's a little bit faster for general queries.