Jake Pilgrim wrote: > Yes, you could use CFtransaction for this type of isolation, but this can > also cause problems that you wouldn't see with cflock. Cftransaction > isoloation='serializabile' for example will give you an exclusive lock to all > tables within the transaction (most restrictive level of isloation).
No it doesn't. Serializability does not require some sort of locking, it requires that parallel transactions will have the same outcome as if they were executed one after another. Locking is an implementation detail, not some purpose. MVCC based databases exploit the difference between mathematical serializability and serializability according to the SQL standard to make sure that exclusive locking is not necessary: no objects will be exclusively locked just because they participate in a serializable transaction. And for instance MS SQL Server uses intend locks on tables (which are not exclusive) combined with exclusive locks on rows (only to be escalated when a transaction has taken 1250 locks). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
