In Pessimistic locking when user wants to update data it
locks the record and till then no one can update data. Other user’s can only
view the data when there is pessimistic locking
In Optimistic locking multiple users can open
the same record for updating, thus increase maximum concurrency. Record is only
locked when updating the record.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
In Pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking
In Optimistic locking multiple users can open the same record for updating, thus increase maximum concurrency. Record is only locked when updating the record.