I think that was actually supposed to be pulled out of the docs. Here's what I was told regarding that setting: "It turns out that the isolation level gain is nearly negligible, and can degrade performance in some cases...found after CFMX Server shipped".
If you did want to try it in your environment, you'd add the line indicated in the release notes to your jrun-resources.xml file for that particular data source. Deb -----Original Message----- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 12:19 PM To: CF-Talk Subject: Macromedia TechNote on Database Performance 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? Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net <http://www.garrisonenterprises.net/> [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] ************************************************************************ ************* ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
