Average Rating: 3.8/5 | Rate this item | 6 users have rated this item.

Expertise: Intermediate
Language: Java

July 15, 2008

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.