Tools that honor the Auto Commit environment will force a commit after the specified number of changes have been made within an enterprise geodatabase transaction.
- This setting works in the same manner as the AUTOCOMMIT enterprise geodatabase initialization parameter.
- This environment can help to prevent transactions from becoming too large and exceeding the database management system (DBMS) logs. See your DBMS documentation for managing transactions.
- A higher commit value can improve performance, but this must be weighed against the possibility of losing edits if storage capacity is reached or an error occurs before the commit.
- Auto Commit—The interval at which transactions will automatically commit. If set to 0, transactions will commit only when an explicit commit is issued.
arcpy.env.autoCommit = interval_value
import arcpy # Set the autoCommit environment to 2000. arcpy.env.autoCommit = 2000