We have a fairly high-traffic ACF 8 site where SQL Server database gets hit with two types of queries:
type 1 - about 1-5 SELECTS per second that have to run as fast as possible *always* (< 1 second) type 2 - about 100-500 "other" queries per day that are allowed to run "slower" (5-20 seconds). (These are reports, automated processes, etc.) I know I can declare "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" on some of those type 2 queries so that they do not issue locks on tables that type 1 requires to do its thing. My question is: if the goal is to make sure type 1 remains as fast as possible, will it help/hurt to also declare "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" on type 1 queries? -- John Bliss - http://about.me/jbliss ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
