dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Java
Expertise: Intermediate
Jul 15, 2008

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Turn Off Auto-Commit for Better Performance

When you first establish a connection to a database, the connection is in auto-commit mode, by default. For better performance, turn auto-commit off. You can do this by calling the connection's setAutoCommit() method and passing it a boolean false, as follows:

conn.setAutoCommit(false);
Be aware, however, that once you turn auto-commit off, you'll have to manage your transactions manually by calling the connection's commit() and rollback() methods.

Amol Somani
 
Thanks for your registration, follow us on our social networks to keep up-to-date