Re: Poor performance when committing on a Connection to a MS Access database
Wednesday, April 18, 2001 06:51 AM
Have you set auto commit off on your connection "conn.setAutoCommit(false);")? If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions which makes things much slower. Hope this helps.