 |  |  |  |  |  |  |  |
optimistic and pessimistic locking
 |
•
•
Join Date: May 2005
Posts: 15
Reputation: 
Solved Threads: 0
Newbie Poster
what is the difference between optimistic locking and pessimistic locking in ado.net
Optimistic vs. Pessimistic Locking
OK Eddy, here goes:
Locking is a method used to protect records that will be accessed by multiple users so that concurrency errors do not occur (when multiple users change records near simultaneously resulting in inconsistencies).
"Locking" refers to preventing access in some way to the file in order to protect it while a user is making an update.
Optimistic locking is better to use when the likelihood of a update conflict is low. This is usually the case when the normal action is adding a record, like in an order entry system. Pessimistic locking is used when the likelihood of such a conflict is high.
Pessimistic locking anticipates contention for the same record, preventing users from selecting a record for editing when another user has already done so. This is often done by relying on the database itself. Most relational databases use this method, only each may use a different standard for the "granularity" considered when making a lock. As an example, SQL Server 2000 locks single rows, while others may lock the entire page or table containing the record to be changed. A drawback is that this type of locking requires that you remain connected to the database the whole time, which can be a bit much to ask. Also, this type of locking can back up on users waiting to access a given record.
Optimistic locking allows multiple users to access the same record for edits, counting on minimal conflicts over data. The "locking" happens after the user tries to save changes on top of someone else's changes. The program logic checks to see if the record has been changed since you opened it. If it has, an error is thrown and the update is rolled back. If no changes are detected, the record is saved as planned.
As you can tell, there are advantages and disadvantages to both. :-|
So the fun part is deciding which approach best suits your needs.
Hope this helps! Good luck!
OK Eddy, here goes:
Locking is a method used to protect records that will be accessed by multiple users so that concurrency errors do not occur (when multiple users change records near simultaneously resulting in inconsistencies).
"Locking" refers to preventing access in some way to the file in order to protect it while a user is making an update.
Optimistic locking is better to use when the likelihood of a update conflict is low. This is usually the case when the normal action is adding a record, like in an order entry system. Pessimistic locking is used when the likelihood of such a conflict is high.
Pessimistic locking anticipates contention for the same record, preventing users from selecting a record for editing when another user has already done so. This is often done by relying on the database itself. Most relational databases use this method, only each may use a different standard for the "granularity" considered when making a lock. As an example, SQL Server 2000 locks single rows, while others may lock the entire page or table containing the record to be changed. A drawback is that this type of locking requires that you remain connected to the database the whole time, which can be a bit much to ask. Also, this type of locking can back up on users waiting to access a given record.
Optimistic locking allows multiple users to access the same record for edits, counting on minimal conflicts over data. The "locking" happens after the user tries to save changes on top of someone else's changes. The program logic checks to see if the record has been changed since you opened it. If it has, an error is thrown and the update is rolled back. If no changes are detected, the record is saved as planned.
As you can tell, there are advantages and disadvantages to both. :-|
So the fun part is deciding which approach best suits your needs.
Hope this helps! Good luck!
|
Similar Threads
- Help required locking down desktop display properties (Windows NT / 2000 / XP)
- locking up the pc. (Viruses, Spyware and other Nasties)
- Record Locking in VB through DAO via MS Access (Visual Basic 4 / 5 / 6)
- Some resolutions to locking up, or 'freezing' (Troubleshooting Dead Machines)
- Creating a locking program (C)
Other Threads in the ASP.NET Forum
- Previous Thread: about CDONTS
- Next Thread: Is it possible to create editable listboxes
Views: 13694 | Replies: 2
| Thread Tools | Search this Thread |
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP.NET
.net 2.0 3.5 access ajax alltypeofvideos anathor application asp asp.net bc30451 browser button c# captcha chat checkbox commonfunctions connection control dataaccesslayer database datagridview datalist development dgv directshow dropdownlist dynamically edit editing editor expose feedback fill flash form formatdecimal formview google gridview iis iis-application iis-appmapping india javascript json list listbox login microsoft migration mouse mssql news numerical opera panel panelmasterpagebuttoncontrols parent problem project radio redirect registration reportemail result richtextbox rows schoolproject search security server session silverlight smoobjects software sql sql-server sqlserver2005 suse textbox theft tracking trust-level unauthorized update url validation vb.net videos vista visualstudio web webapplications webprogramming webservice website xsl youareanotmemberofthedebuggerusers
