I doubt you will notice much difference in performance unless you are really going through that code many times a second. While it is good to have code that is optimized and doing as it should at some point you have to consider if it is worth the effort. There are many arguments about code bloat but the simple fact is that people time is expensive. The time spent in making the change and testing the change may not produce results that justify the effort.
At one time there may have been some selects and an update or insert within the cftransaction block. The updates or inserts may have been removed and the cftransaction was not noticed. It happens with code, I myself being guilty more than once. Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Pat Larrea [mailto:hiralal...@gmail.com] Sent: Wednesday, January 21, 2009 9:30 AM To: sql Subject: Re: cftransaction for SELECT statements 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:3183 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
