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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
