Skip to main content

Auto Commit (Environment setting)

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.

Usage notes

  • 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.

Dialog syntax

Auto Commit—The interval at which transactions will automatically commit. If set to 0, transactions will commit only when an explicit commit is issued.

Python syntax

arcpy.env.autoCommit = interval_value

Name Explanation

interval_value

  • 0—Transactions will commit only when an explicit commit is issued.

  • interval—Transactions will automatically commit every interval changes.

  • ""—Default to automatically commit every 1,000 updates.

Scripting syntax 

import arcpy

# Set the autoCommit environment to 2000.
arcpy.env.autoCommit = 2000