Pessimistic locking and optimistic locking

Describe briefly the difference between pessimistic locking and optimistic locking?

E

Expert

Verified

Optimistic locking supposes no transaction conflict will happen and deals with the consequences when it does. Pessimistic locking supposes that conflict will happen and so prevents it ahead of time with locks. Basically, optimistic locking is preferred for the Internet and for many intranet applications.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.