Autocommit

In the context of data management, autocommit is a mode of operation of a database connection. Each individual database interaction (i.e., each SQL statement) submitted through the database connection in autocommit mode will be executed in its own transaction that is implicitly committed. A SQL statement executed in autocommit mode cannot be rolled back.

Autocommit mode, in theory, incurs per-statement transaction overhead, having often undesirable performance or resource utilization impact. Nonetheless, in systems such as Microsoft SQL Server, as well as connection technologies such as ODBC and Microsoft OLE DB, autocommit mode is the default for all statements that change data, in order to ensure that individual statements will conform to the ACID (atomicity-consistency-isolation-durability) properties of transactions.[1]

The alternative to autocommit mode (non-autocommit) means that the SQL client application itself is responsible for issuing transaction initiation (start transaction) and termination (commit or rollback) commands. Non-autocommit mode enables grouping of multiple data manipulation SQL commands into a single atomic transaction.

See also

  1. ↑ Autocommit transactions. http://technet.microsoft.com/en-us/library/aa213069(v=sql.80).aspx
This article is issued from Wikipedia - version of the 2/26/2014. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.