skip to main content
Reference : Designing ODBC Applications for Performance Optimization : Managing Connections and Updates : Choosing the Right Transaction Model
  

Try DataDirect Drivers Now
Choosing the Right Transaction Model
Many systems support distributed transactions; that is, transactions that span multiple connections. Distributed transactions are at least four times slower than normal transactions due to the logging and network round trips necessary to communicate between all the components involved in the distributed transaction. Unless distributed transactions are required, avoid using them. Instead, use local transactions when possible.