> I think you're missing Jochem's point, which is simply that > if you have multiple servers, CFTRANSACTION will work fine, > placing the requisite locks as needed.
My problem with it is that if you put 3-4 queries inside a CFTRANSACTION instead of using one TSQL transaction, then it'll have to "deadlock" the DB Server for it to handle the transaction properly Thus, using CFTRANSACTION on a clustered environment will work horribly compared to writing it using transactions in a query or SP Say you want to do an insert, then get the Identity field, then do an update related to that Identity, you're gonna cause real performance issues, because the database can't handle the 3 commands as well as it could if you wrote it decently in TSQL... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
