Another use would be if you want the DB to be consistent for the whole set of queries; in this case you would use the serializable isolation level.
mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/21 Robert Rawlins: > Just as a quick note on this, there are some instances when using > cftransaction around a SELECT query can be beneficial, for instance in a > busy database sometimes you won't want SELECT queries waiting around for > resource locks to be dropped on tables that are being inserted into, you > could then use <cftransaction isolation="read_uncommited"> and it'll read > 'dirty' data. > > This is discussed on Ben Nadels blog which I was reading just a week or so > ago. > > http://www.bennadel.com/blog/477-SQL-Server-NOLOCK-ROWLOCK-Directives-To-Imp > rove-Performance.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3181 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
