Apparently MyISAM is faster than InnoDB
The only advantage InnoDB has over MyISAM is that it supports row locking, while MyISAM only supports table locking.
Therefore, if lots of reads and writes are constantly being done to a very large table, it eliminates the constant database errors that using a MyISAM table would cause from the overload.
InnoDB would therefore be a tad more reliable when you don't mind taking a small performance hit in exchange for not suffering from table locking issues.
one other thing I found is
while using Hibernate commit statements, myISAM works even with out commit statement, but InnoDB requires commit for every transaction. its advantaeous providing rollback support.
more here
No comments:
Post a Comment