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



Home Answers Viewqa JDBC consider optimistic versus pessimistic approaches

Have Programming Question? Ask it here!
 
 
 


Clark
consider optimistic versus pessimistic approaches
1 Answer(s)      3 years and 10 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
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
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
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
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
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
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
Reading Request Information
in a JSP page. Consider an html page that prompts the user to enter his/her
Same Day Jaipur Trip from Delhi
Indian capital, most of the visitors consider a same day trip to Jaipur city
Common Interview Questions Page - 11
Common Interview Questions Page - 11       Question: 90. Do you consider yourself organized? And do you manage your time well? Answer: Here you have to proof your skills
VoIP Software
VoIP Software          VoIP Telephone Solutions If you have a fast connection to the Internet (say 64kbps or more) you should consider Voice Over IP (VoIP
Web application - business layer
performance, and consider using a message-based interface. This works well... typing them separately or with versus
Hibernate Training
; Optimistic Locking   ... Association Versus Component Many-to-one  Components  One-to-one  Component Versus One
EJB Container or EJB Server
are used to control the concurrency. Optimistic Locking Pessimistic Locking
EJB Container or EJB Server
are used to control the concurrency. Optimistic Locking Pessimistic Locking
open source - Java Beginners
. Some consider open source as one of various possible design approaches, while others consider it a critical strategic element of their operations. Before open
C++
C++  Describe the principle advantages of deploying a linked list versus a static array when implementing a Queue or a Stack
Outsourcing Communication Tips,Useful Cultural Tips in Offshore Outsourcing,Communication and Culture Tips
or unacknowledged matters. The parties involved may have different approaches.... There could be issues like candor versus diplomacy and explicit communication versus implicit communication. 'Yes', 'maybe',' no' and silence mean different
Java programming approch
Java programming approch  What are the approaches that you will follow for making a program very efficient
What is Niche Social Network?
If you consider making a list of 5 most influential things that changed the way we interact with people in the recent time, definitely social networking... are stubbornly pessimistic about the possibility of this new virtual social space you
JDO Implementations
. Speedo main benefits: a.) Possible choice of optimistic or pessimistic
Database Sql question? - WebSevices
Database Sql question?  Given relation r (a, b,c), show how to use the exstended SQL features to generate a histogram of c versus a, dividing a into 20 equal-sized partions (that is where each partition contains 5 percent
The Warfare between iOS and Android Platform
of this warfare between Android and iOS platforms. Android versus iOS Android... platform is a bit faster in response than the iOS. Please don't consider us... of people than Android, according to a latest survey. Almost 75% versus 25%! A sure
What is Open Source?
use of different agendas and approaches. A Little History The term ‘open... of closed development versus open development as seen through the Internet
Flash based Chat System - WebSevices
and cons of the two approaches. What are the existing relevant solutions that can
Open Source Knowlegde base Software
, have focused on the ROI of upgrading a Windows installation versus switching... new personnel?always expensive propositions?versus merely paying for licenses... we consider open-source software projects as interactive systems based on dense
Differences between the String, StringBuilder, and StringBuffer classes
Differences between the String, StringBuilder, and StringBuffer classes StringBuffer versus String Java provides the StringBuffer and String classes... possible. If the functionality of the String class is desired, consider using
Your competitor presses you to reveal some confidential information about your current or previous employer.
this situation, consider the interviewer’s motives. There could be two reasons..., fulfilled person and that you have a cheerful and optimistic outlook. E.g.
 

 

 

DMCA.com