Difference of Optimistic & Pessimistic locking in ado .net

It is containing all topics related to Visual Basic, .NET Framework, Web Resource, GDI etc.
Ladva Nidhi
Posts: 295
Joined: Sat Sep 20, 2014 5:26 pm
Contact:

Difference of Optimistic & Pessimistic locking in ado .net

Postby Ladva Nidhi » Sun Oct 26, 2014 10:34 am

What’s difference between “Optimistic” and “Pessimistic” locking?


Guest

Re: Difference of Optimistic & Pessimistic locking in ado .n

Postby Guest » Tue Jul 28, 2015 6:43 am

In pessimistic locking, when a user opens a data to update it, a lock is granted. Other users can only view the data until the whole transaction of the data update is completed.

In optimistic locking, a data is opened for updating by multiple users. A lock is granted only during the update transaction and not for the entire session. Due to this concurrency is increased and is a practical approach of updating the data.


Return to “Visual Basic .NET and ASP.NET”

Who is online

Users browsing this forum: No registered users and 3 guests