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

Explain Add References Dialog Box, What is the difference between "using Sy...

What is the difference between "using System.Data;" and directly adding the reference from "Add References Dialog Box"? When you compiles a program using command line, u add th

Develop a windows backup application, Develop a Windows Backup Application ...

Develop a Windows Backup Application Application Goal The goal is to prepare an easy to use application that provides the user peace of mind that all of their firewalls are b

Develop outlook add-in for all versions, Develop Outlook Add-In for all ver...

Develop Outlook Add-In for all versions I need simple code for Outlook(express,2003,2007,2010,2013) Add-In with functionality to repeatedly send CC to the specified email(s), th

Use a checkbox in a datagrid, How to use a checkbox in a datagrid? The ...

How to use a checkbox in a datagrid? The steps to be done are as follows:- 1)    In the ASPX page you have to add Itemtemplate tag in datagrid. 2) I

What are the benefits of using of ado.net in .net 4.0, What are the benefit...

What are the benefits of using of ADO.NET in .NET 4.0. The following are the benefits of using ADO.NET in .NET 4.0 are as follows: Language-Integrated Query (LINQ) - Adds

How is anchoring different from docking, How is anchoring different from do...

How is anchoring different from docking? Docking refers to attaching a control to either an edge (top, right, bottom, or left) or the client area of the parent control. On the

Describe session handling in a web farm, Describe session handling in a web...

Describe session handling in a web farm, how does it work and what are the limits ?    In ASP.NET there are three ways to manage session objects. One support the in-proc mechani

Immediate need in website update, Website update... Immediate need I wan...

Website update... Immediate need I want someone experienced in ASP.NET who can set up PayPal on my website by Feb. 1st. I would similarly like to have some changes made in the t

I would like to develop a new website, I would like to develop a new websit...

I would like to develop a new website to compete with an existing one: greatandhra I would like the new website to be less flashy, more content driven and be inspired from below

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