Thank you both, Yes, my understanding was exactly what Ray kindly explained, but I saw some comments about the use of isolation attribute and it made me unsure about which is better, removing this tag or adding 'read_uncommitted' attribute to this tag. From what I read in the page Rob put, SQL server put locks on the resource whether or not I put cftransaction tag, therefore, to force the query to read data without waiting for the drop of locks, it is recomended to use <cftransaction isolation="read_uncommited"> always (of course when the dirty read is acceptable). Anyway should be the time to compare the performance of each case, with and without this tag.
Thanks again, but further information, if any, is still welcome. Pat ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3182 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
