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
MVC -C# Single Page Application Project Description: Construct a site similar to prototype: To explain briefly: 1) Single Page Application 2) Loginig funcionality

We want help in ASP.NET MVC Developer I want an expert ASP.NET MVC, C#,LINQ, SQL Server2012, JQuery, Angular JS, Bootstrap Responsive UI developer for more 6+ months. Desired

What is "Common Type System" (CTS)?  CTS define all of the basic types that can be used  in the .NET Framework and the operations performed on those type. All this time we have

Name the control that exposes the LINQ features to Web developers through the ASP.NET data-source control architecture. The LinqDataSource control exposes the LINQ features to

Importance of IT governance Governing and managing information technology is a crucial activity in organizations to generate business value. According to Ross & Weill (2004), f

how can i construct er diagram for payroll managment

What is impersonation in ASP.NET? By default, the ASP.NET executes in the security context of a restricted user account on the local machine. Sometimes you require to access ne

What is CAR (Causal Analysis and Resolution)? The basic purpose of the CAR is to analyze all the problems, defects, and good practices/positive triggers in projects, perform a

How can you use Hidden frames to cache client data? This technique is implemented by developing a Hidden frame in page which will have your data to be cached. T cols="100

Human Aimbot and CSGO Wallhack Need a CSGO hack which can Aimbot and wallhack realistically. Must be VAC Proof, and ESL proof, as well as Overwatch proof (in teh case of thei