ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Auto Commit (Environment setting)

  • Usage notes
  • Dialog syntax
  • Scripting syntax

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

ParameterExplanation

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

Related Topics

  • Executing SQL using an ArcSDE connection
  • An overview of geoprocessing environments
  • Environment levels and hierarchy
  • Setting geoprocessing environments
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal