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

Unlock software or make similar one, Project Description: I need to unlo...

Project Description: I need to unlock software or make a similar kind of software. It is presently installed in my PC and I will provide you installation files if needed. It wil

Downloadable software for a pc computer and mac, Downloadable software for ...

Downloadable software for a PC computer and Mac Project Description: "The software" can be sold as a downloadable purchase. I must have all copy rights to "the software" when

Different locks in sql server, What are the different locks in SQL SERVER? ...

What are the different locks in SQL SERVER? Depending on the transaction level there are six types of lock that can be acquired on data :- 1)Intent: The intent lock des

What is windows workflow foundation, What is Windows Workflow Foundation (W...

What is Windows Workflow Foundation (WF)? Windows Workflow Foundation (WF) is a technology that was first introduced in .NET Framework 3.0. WF having of a programming model, a

Wowza expert required, Wowza expert required Project Description: See...

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

Develop a google map fix .net site on android, I have to develop a Google M...

I have to develop a Google Map Fix .NET Site on Android(maybe Cross Browser issue) Project Description: A developer has implemented a characteristic which involves data from

Finding largest array element - c# program, Finding Largest Array Element -...

Finding Largest Array Element - C# Program I am unable to make out the Largest Array Element in C# language. Can anyone suggest me any example for this.

Explain different types of xml application programming, Explain different t...

Explain different types of XML Application Programming Interface (API). The following are two main parts of XML parsers: Tree-based API - Compiles an XML document into a tre

Lock escalation, What is LOCK escalation? The Lock escalation is the pr...

What is LOCK escalation? The Lock escalation is the process of converting of the low level locks (such as row locks, page locks) into the higher level locks (such as table lock

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