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 ArcSDE transaction.

Usage notes

• This setting works in the same manner as the AUTOCOMMIT ArcSDE initialization parameter.
• This parameter can help in preventing 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—Interval at which transactions will automatically commit. If set to 0, transactions will commit only when an explicit commit is issued.

Scripting syntax

arcpy.env.autoCommit = interval_value

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

autoCommit syntax

import arcpy

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