Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC consider optimistic versus pessimistic approaches
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Clark
consider optimistic versus pessimistic approaches
1 Answer(s)      3 years and 11 months ago
Posted in : JDBC


Why should I consider optimistic versus pessimistic approaches to database updates?


Advertisement
View Answers

November 15, 2010 at 5:41 PM


Hi Friend,

Use Pessimistic locking if the lock period is short while for long lock period, it is better to use Optimistic locking. It will improve the overall performance.

If there are too many transactions then it is better to use pessimistic locking as the roll-back cost can exceed the locking cost.

Thanks



Related Tutorials/Questions & Answers:
consider optimistic versus pessimistic approaches
consider optimistic versus pessimistic approaches  Why should I consider optimistic versus pessimistic approaches to database updates
optimistic concurrency
optimistic concurrency  What is optimistic concurrency
Advertisements
Approaches to Outsourcing,The Various Approaches to Outsourcing,IT Outsourcing Approaches
The Various Approaches to Outsourcing Introduction It is important to understand the various approaches to outsourcing, so that the most appropriate one may be chosen. The broad categories of outsourcing are as follows
Java String.equals versus ==
Java String.equals versus ==  Java String.equals versus
Encapsulation versus Absraction
Encapsulation versus Absraction  I believe no one in this world knows real difference between Encapsulation and Abstraction , one of them is me as well but if there is anyone who really understand the difference please help me
Windows 8 versus Android
the potential success of all the platforms and in talking of Windows 8 versus Android... versus Android comparison apparent on user experience. Stature The relative... time. Windows 8 versus Android, in all competitive aspects this is how it stands
Applet versus Application
Applet versus Application       Applets as previously described, are the small programs... consider the case of an application named ClassA to which we have to pass the arguments
jdbc
what is difference between optimistic and pessimistic locking  what is difference between optimistic and pessimistic locking   Pessimistic... is requested.While Optimistic locking is where a record or page is only locked when
JSTL: Set Session Attribute
JSTL: Set Session Attribute          Consider a situation where we are using the jstl and there is a need to set a variable in the session. You all know
How to delete a table in mysql
How to Delete a Table in MySQL       Consider a situation where we need to delete a table from a database.  To delete a table from the database firstly we need
EMFScript
EMFScript       Although transformation is an essential operation of model driven approaches, others kinds of model manipulation are required and are under study
Simplified Application Development with Struts, Hibernate and Spring
Simplified Application Development with Struts, Hibernate and Spring       This tutorial provides an outlook of the alternative lightweight approaches for building J2EE enterprise
Hybrid Mobile Application Development
the Native and mobile Web approaches. A web-to-native abstraction layer allows
J2EE Tutorial - Java Bean
J2EE Tutorial - Java Bean       To bring out the differences between the different appraoaches,  we will consider a simple case where the user types his
Getting Columns Names using Servlets
Getting Columns Names using Servlets       Consider a situation where there is a need to know about the name of the columns without touching our database. As we
Getting Number of Columns
Getting Number of Columns       Consider a situation where there is a need to know about the number of columns in the table without touching our database. As we are the programmers
Getting Number of Rows
Getting Number of Rows       Consider a situation where we want to know about the number of rows in the particular database table without touching our database. As we
Deleting Rows From Table
Deleting Rows From Table       Consider a situation where we have entered some wrong data and in later situation it starts giving problem to the organization. Rather
JSTL for Loop <c: forEach>
JSTL for Loop <c: forEach>           Consider a case where we want to do something with a collection like an array, retrieving one element
Inserting Image in a database Table
Inserting Image in MySql Database Table       Consider a case where we want that along with the name of the person and its information, his image should also
Validating XML document with a DTD
Validating XML document with a DTD If an xml document is well formed i.e. syntactically correct, then it doesn't mean it is valid also. To consider an XML document valid it must be validated, or verified, against a DTD. DTD
J2EE Tutorial - Session Tracking
J2EE Tutorial - Session Tracking       Let us now consider a case where the object  is not available in the webserver but in another remote machine
VoIP Free Software
VoIP Free Software          Free VoIP Software Telephone solution If you have a fast connection to the Internet  you should consider Voice Over IP (VoIP
Creating a MySQL Database Table to store Java Types
Creating a MySQL Database Table to store Java Types       Dear user, consider a case where we need to store a java types in our database table. Now one question may arise in your
PHP Class Object
PHP Class Object: In object oriented programming a class can be an abstract data type, blue print or template. You could consider the name of a class as noun like name of a person, place or thing.  For example Fruit is a class, where
Career in Fashion
, there are a couple of things that you should consider before deciding towards this career. One... consider being a fashion journalist, for example, which is one of the more stable... if that is what you are looking for, you should consider the next career in fashion we
Aspects of Social Media Marketing
Aspects of Social Media Marketing to Consider There are hundreds and possibly..., there are some aspects and positive points that are very important to consider. Traffic... It All into Account All of these aspects and more are essential to consider before
Choosing the Right Sites for Social Media Marketing
for their social media marketing. There are several key aspects to consider when... must consider who the members are and if there is a certain niche
Same Day Jaipur Trip from Delhi
Indian capital, most of the visitors consider a same day trip to Jaipur city
Reading Request Information
in a JSP page. Consider an html page that prompts the user to enter his/her
Advertisements
 

 

 

DMCA.com