|
|
When a connection has auto-commit disabled, multiple database statements can be executed in the same transaction. Because transactions tend to use a significant number of resources, fewer transactions result in better performance. Therefore, if an application requires executing multiple statements, best practice is to disable auto-commit, and use transactions to group a number of statements into one unit of work. Keep in mind that if a transaction has a very large number of statements, the database can experience memory resource issues.
