Joshua Miller wrote: > Does anyone have any information on changing the Isolation Level on MS > SQL Server 2000 as referenced in: > http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote > s_mx.html#perf > > Does this have much impact on performance? If so, how do I do it? There > is no setting in the CFAdministrator to change this value, and I don't > see a connection string box as referenced in the technote. I was > thinking connection strings were only needed if the driver didn't exist > or in some special instances ... do I need to use a connection string to > setup my connection to SQL Server in this manner?
Focus on the second part. It can be quite usefull to change this setting for specific transactions, but if anything read_commited is a to low level of isolation for general queries. (For instance, the SELECT MAX(ID) + 1 -> INSERT trick to get the next value for a primary key technically requires a serializable isolation level.) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
