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

Describe the layer of the .net framework, Question: (a) Using the help...

Question: (a) Using the help of a diagram, describe the layer of the .NET framework that sits between Visual Basic.NET 2005 and the operating system. (b) Explain the charac

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.

Need desktop application for inventory system, Need desktop application for...

Need desktop application for inventory system Project Description: For my distribution unit, I want inventory system (purchase / sale / returns / reports ) based on customize

For loop, create a table using class file

create a table using class file

Appsetting section in "web.config" file, What is AppSetting Section in "Web...

What is AppSetting Section in "Web.Config" file? Web.config file describe the configuration for a webproject. By Using "AppSetting" section we can define user defined values. T

Information retrieval from multi-agent system, Information Retrieval from M...

Information Retrieval from Multi-Agent System with Data Mining in Cloud Computing Project Description: I have planned one research model on "Information Retrieval through Mul

Arithmetic operations, write a program in C# to perform arithmetic operatio...

write a program in C# to perform arithmetic operation

C# api to grab option price from cboe web site, C# API to grab option price...

C# API to grab option price from CBOE web site Project Description: On the web page below, user will download option prices of Stock or Index. For example, if you put "VXX" i

File upload in asp.net, upload files using file upload control to google dr...

upload files using file upload control to google drive

Benefits and limitations of using hidden frames, What are benefits and limi...

What are benefits and limitations of using Hidden frames 1)    The benefits of using hidden frames are as follows: 2)    More than one data field can cache. 3)    The abi

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