Difference between "optimistic" and "pessimistic" locking, DOT NET Programming

Assignment Help:

What's difference between "Optimistic" and "Pessimistic" locking?

In the pessimistic locking when user wants to update a data it locks the record and till then no one can update data. The Other user's can only view the data when there is a pessimistic locking.

In the optimistic locking many users can open the same record for updating,and hence increases maximum concurrency. The Record is only locked when updating the record. This is the most preferred way of locking practically. In today's time the browser based application is very common and having the pessimistic locking is not a practical solution.


Related Discussions:- Difference between "optimistic" and "pessimistic" locking

Indexes, What are indexes? The Indexes in the SQL Server are similar to...

What are indexes? The Indexes in the SQL Server are similar to the indexes in books. They help SQL Server to retrieve the data quickly.These are classified into clustered and n

Current culture of the environment in windows and asp.net, How we get the c...

How we get the current culture of the environment in windows and ASP.NET? The "CultureInfo.CurrentCulture" represents the current culture of the environment. For illustrate if

Generate function create signed body, The only difference is that I need th...

The only difference is that I need the most new version. Things have changed a little since then (the key has), so I need this done freshly. I require the result in C#, sourceco

I need desktop app for website, I need Desktop App for website Project D...

I need Desktop App for website Project Description: We own a big website. Basically we want a desktop app or mobile app for our website. So people download and have our websi

Uml, What is UML? The Unified Modeling Language (UML) is a graphical la...

What is UML? The Unified Modeling Language (UML) is a graphical language for documenting, specifying, visualizing,  constructing, and  the artifacts of a software-intensive sys

Develop a earnings calculator for my paid to click website, Develop a Earni...

Develop a Earnings Calculator for my Paid to Click Website Project Description: I want a calculator which will show my members how much they could earn, with value per click,

ASP.NET Web Service Help C#, I need help figuring out how to capture text b...

I need help figuring out how to capture text box values from C# ASP.NET and send them from one class to another after being processed by a method.

Vb 2010, how to create log in form using vb 2010

how to create log in form using vb 2010

Define dataset object, How can you identify whether or not any changes are ...

How can you identify whether or not any changes are made to the DataSet object as it was last loaded? The DataSet object provides the following two methods to track down the ch

Types of diagrams in uml, How many types of diagrams are there in UML? ...

How many types of diagrams are there in UML? There are nine types of diagrams in the UML as shown below:- 1)Use case diagram: The use case diagram describe "WHAT" of a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd