devxlogo

Turn Off Auto-Commit for Better Performance

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.

devx-admin

Share the Post: