MySQL Forums
Forum List  »  Quality Assurance

Re: Row locking
Posted by: d batz
Date: November 23, 2011 01:55AM

I think will depends on the processes within your project.

We had that issue before but from our experience is that......
InnoDB is:
*no row lock - multi-user(UPDATE, INSERT / SELECT)
*slow in searching (rapid queries)

MyISAM is:
*row lock
*fast in searching (rapid queries)

Options: ReplyQuote


Subject
Views
Written By
Posted
2768
October 04, 2011 01:41AM
Re: Row locking
1295
November 23, 2011 01:55AM
1108
February 12, 2012 09:29PM


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.