Paul, The downside is that you are adding overhead to each request by making them negotiate a connection rather than selecting from existing connections. This is worth it in your case however, as it seems to solve your performance problem on another level. Access has a connection "threshold" for stability that I've heard is as low as "25 connections (i.e. more than 25 connections and performance begins to degrade) and as high as 75. Different folks say different things - but everybody says this ... "don't run your production sites on access" <ha>. It sounds like you are well on your way to solving this problem by migrating to SQL. The only other tip that "some" have made regarding access is that the OLE DB drivers tend to perform better.
-mk -----Original Message----- From: Paul Sinclair [mailto:lists@;mail1.kingcrest.com] Sent: Wednesday, November 06, 2002 9: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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
