> 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/r > eleasenotes_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?
My information about changing this would be to recommend that you not change it. While it may give you better performance in some cases, it would do so at the cost of any transactional integrity of your data! Not so hot for your new e-commerce application, for example. In general, you'd want an isolation level of READ_COMMITTED at a minimum. The technote mentions that you could set it to READ_UNCOMMITTED, which basically tells the database, "don't worry about those silly locks, and to hell with anyone changing records right now, just do what I tell you as fast as you can!" This may be desirable behavior in very limited circumstances, such as reporting interfaces. If you did want to do this, you'd have to edit the appropriate text file as mentioned in the link you posted. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
