Avoid inserts in autocommit mode if possible

Avoid inserts in autocommit mode if possible To improve insert performance, avoid inserts in autocommit mode if possible. autocommit mode

Inserts can be painfully slow in autocommit mode because each commit involves an update of the log on the disk for each INSERT statement. The commit will not return until a physical disk write is executed. To speed things up:

Run in autocommit false mode, execute a number of inserts in one transaction, and then explicitly issue a commit.
If your application allows an initial load into the table, you can use the import procedures to insert data into a table. will not log the individual inserts when loading into an empty table using these interfaces. See the and the for more information on the import procedures.