What is difference between Optimistic and Pessimistic locking?

Total Post:782

Points:3910
C# 
C#
 2196  View(s)
Ratings:
Rate this:
  1. Post:782

    Points:3910
    What is difference between Optimistic and Pessimistic locking?

    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.

      Modified On Mar-27-2018 04:37:01 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!