We're investigating performance issues in a db app that is throwing lock contention errors. One of the things we are looking into is using the UPDLOCK optimizer hint (this is for SQL Server 2000). However, we have a situation where a number of queries are run inside a cftransaction tag. We can't move the logic outside, generate the sql, then execute it in our own transaction because the subsequent queries rely on data returned from previous queries in the transaction. I know I could rewrite this all into a stored procedure, but budgetarily, this isn't an option right now.
So, my question is this: can you use your own transaction hints inside of queries that are contained inside a cftransaction? Or will the cftransaction just set the lock level and disregard the hints contained in the sql in the various cfqueries? Fwiw, I'm running 7.0.2 on Windows 2003. Thanks, Judah ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
