DISTRIBUTED DATABASE TRANSACTIONS

Transactions do not scale; the database needs to be locked while the transaction takes place. When this happens you are preventing users from accessing the database. There are exceptions to this, e.g. when you need to pay for something on a site, then a database transaction must be used. A Transaction requires that the current “state” of the user session be remembered and maintained; this is hard to do on high volume sites.