Hi all, I have a question about the use of cftransaction tag. I've been reviewing the source code of the system of my company, where I started to work recently, and found that in some parts this tag is used just to wrap some (about 10) SELECT statements ( without INSERT, UPDATE o DELETE). I doubt that this kind of use has an positive effect, on the contrary it seems to me that it affects the performance. I don't have much experience in Coldfusion, so I'm not sure if my impression is correct but I've never seen any example of the use of cftransaction tag only with SELECT statements.
I'd appreciate if someone could tell me how this use of cftransaction afects the performance of retrieving data. The DB we use is SQL Server 2000. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3178 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
