Thanks for the information - doesn't seem like a very good TechNote if everyone says it's a bad idea :)
I'm having luck just changing some queries to Stored Proceedures ... I'd like to use caching, but I can't figure out a way to specify dynamic query names. Anyone have a method - I'm sure it's not that complicated, but I'm functioning on about 2 hours of sleep today. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. 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 [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 2:15 PM To: CF-Talk Subject: RE: 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/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
