Kbase P104368: How much of a performance impact can one expect when implementing two-phase commit
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/7/2009 |
|
Status: Verified
GOAL:
How much of a performance impact can one expect when implementing two-phase commit
GOAL:
How does two-phase commit effect performance
FACT(s) (Environment):
All Supported Operating Systems
Products / Versions
OpenEdge Category: Database
FIX:
Two-phase commit ensures that distributed transactions occur consistently across all databases. This requires extra overhead and we expect some performance degradation. The performance hit experienced will depend on many things. A few factors to consider would be the complexity of the transactions, how many databases are involved, the location of the databases, and the number of changes implemented across databases . The change in performance while running two-phase commit is related to the specific conditions under which it is being used.