On Fri, Sep 30, 2011 at 11:45 PM, John M Bliss wrote: > type 1 - about 1-5 SELECTS per second that have to run as fast as possible > *always* (< 1 second)
> 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? It would help. What would help equally but would IMHO have less side effects would be to use snapshot isolation. That is an isolation level that provides serializability according to the SQL standard, even though it is not true mathematical serializability. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:347863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
