Another thing to be aware of is that Maintained DB connections are actually cached by CF (I'm pretty sure); so if a network outage causes an error when attempting to connect to a DB, CF can cache that error, and prohibit the DB connection even when the network is back up.
This may not really be an issue on a local connection to access; but then again, why would you be concerned about performance on such a configuration. IGOR ILYINSKY CREDIT|FIRST SUISSE|BOSTON GLOBAL WEB SERVICES -----Original Message----- From: Matt Robertson [mailto:matt@;mysecretbase.com] Sent: Wednesday, November 06, 2002 11:29 AM To: CF-Talk Subject: RE: Downside to disabling "Maintain Database Connections As I understand it, disabling that setting is the recommended best practice for Access. Keeps things from crashing outright, so in this narrow circumstance there is no downside. An article on this was in the KB somewhere. It was entitled along the lines of ''using access in production environments''. I couldn't find it by searching for "access". Whatever happened to the plain ol' KB? Did it get absorbed into something? I couldn't even find the thing on the MM site. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 7:43 AM To: CF-Talk Subject: Downside to disabling "Maintain Database Connections I posted a note yesterday re several sites running veeerrrrrrrry slow on a server. I have a couple sites that are MS Access databases. I am in the process of moving these to SQL but in the interim I need to keep the sites up. I found that by disabling the "Maintain Database Connections" setting in the ODBC configuration for these Access databases that it seems to take care of the problem for the most part. I am just wondering what the downside is to disabling that setting? Thanks for advice. Paul Sinclair ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
