A trend with high volume Web sites is NOT to use database transactions. The rationale being that they harm performance on a large scale, especially when data is distributed throughout several physical databases thus requiring distributed transactions. Many other database facilities such as referential integrity, sorting, triggers and stored procedures are implemented in application code for the same reasons.
http://martinfowler.com/bliki/Transactionless.html
No comments:
Post a Comment