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

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.

Posted Date: 9/24/2012 5:13:27 AM | Location : United States







Related Discussions:- Difference between "optimistic" and "pessimistic" locking, Assignment Help, Ask Question on Difference between "optimistic" and "pessimistic" locking, Get Answer, Expert's Help, Difference between "optimistic" and "pessimistic" locking Discussions

Write discussion on Difference between "optimistic" and "pessimistic" locking
Your posts are moderated
Related Questions
Project Description I require a Automated penny auction bidder software (bidder robot, sniper software, Autobidder ) that put bid at specific milliseconds Nanoseconds from the e

How can we use Culture Auto in project? We will make a very simple login screen which we will try to use for English as well as the Greek. The login screen will display Engl

I want Workflow Designer (HTML5) Project Description: I am seeking an HTML5 designer for a custom workflow tool. It should have drop and drag functionality. Saving it as XML

Wowza expert required Project Description: Seeking wowza expert to teach our webmaster. To provide: How configure wowza to live transcoder. How allow add live transc

Project Description: i will testing some software which you need and i promise to do my job is the best way, and as fast as possible. Skills required: .NET, MySQL, C# P

Explain project life cycle. Figure: -Life cycle of a project There are 5 stages of any project initiating, planning, executing, controlling, & closeout. These are the


Explain the new features in ADO.NET Entity Framework 4.0. ADO.NET Entity Framework 4.0 is introduced in .NET Framework 4.0 and contain the following new features: Persisten

I want to develop SMS application with auto reply based on the content of the message using gsm modem. eg.Student results checking using cell phone via sms. How do i do this?

The problem statement is pretty simple. We need a software implementation of a Point of Sale terminal at a typical store. The users of the system are the cashiers sitting at the sa