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
Name the two properties of the GridView control that have to be specified to turn on sorting and paging. The properties of the GridView control that require to be specified to

Write a XML with database with book details (BOOK ID, Title, Author, subject, published Year, language, vendor, price)

What is Multi-tasking? It is a feature of the modern operating system with which we can run multiple programs at the same time for example Word, Excel etc.

In what order do the events of an ASPX page execute. As a developer is it important to understand these events?   If you try to access it in Page_Load that is way previous than

How to Learn Dot Net Online and get online certificate ?

VB.NET Questions Project Description: Need help to solve questions of VB.NET Skills required: .NET, Software Development, C# Programming, Visual Basic, Windows Deskt

How can you raise custom errors from stored procedure? The RAISERROR statements are  used to produce an ad hoc error message or to retrieve acustom message which is stored in t

Nutritional properties of Processing food Processing food, you may have realized that many desirable changes occur, which include development of pleasing colours and flavors, i

What is the difference between OLEDB Provider and SqlClient? With respect to usage, there is no difference among OLEDB Provider and SqlClient. The dissimilarity lies in their p

Jquery and MVC 4.5 Training Session I am looking who have industry experience working on Microsoft Technology ( MVC 4.5 ) and Jquery, who will take live online session and provi