Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What’s difference between “Optimistic” and “Pessimistic” locking
What’s difference between “Optimistic” and “Pessimistic” locking ?
✍: Guest
In pessimistic locking when user wants to update data it locks the record and till then no
one can update data. Other user’s can only view the data when there is pessimistic locking.
In optimistic locking multiple users can open the same record for updating, thus increase
maximum concurrency. Record is only locked when updating the record. This is the most
preferred way of locking practically. Now a days browser based application is very common
and having pessimistic locking is not a practical solution.
2007-10-24, 4871👍, 0💬
Popular Posts:
How to make elements invisible? Change the "visibility" attribute of the style object associated wit...
What are the different accessibility levels defined in .NET ? Following are the five levels of acces...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.
How to reduce the final size of an executable file? Size of the final execuatable can be reduced usi...
Can you explain different software development life cycles -part II? Water Fall Model This is the ol...