Thanks. I'll give that a try... On Sat, Oct 1, 2011 at 2:35 AM, Jochem van Dieten <[email protected]> wrote:
> > 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:347867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
