Will the Guru

Category: Database

  • Optimistic Lock vs Pessimistic Lock

    What is Lock? Lock is a technique that assures data integrity and atomicity when multiple processes/applications access database concurrently. There are different levels of locking, but from this post, we will focus on transactional locking, especially Optimistic Lock and Pessimistic Lock for concurrency control. Optimistic Lock Optimistic Lock is a…