It's certainly due for an update. Debbie is looking into it. Christian
On Thursday, January 16, 2003, at 05:04 PM, Joshua Miller wrote: > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
