you are correct, MM/Allaire best practices for Access DBs says not to use connection pooling.
see http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540&Method=Full </rob> -----Original Message----- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 2:26 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Using SQL Server maintaining the connection would be advantageous because their wouldn't be the overhead for making a new connection, logging in, etc. In Access I don't think it matters. It is only Access after all. If I get concerned about performance of a site based on Access, I upgrade the site to SQL Server if CF's query caching wont do the trick. I believe it's actually reccomended that connections to Access databases are not maintained for memory reasons. jon Mike Kear wrote: > What's the advantage of locking the server on to the database at all? Is it > performance? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -----Original Message----- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Subject: Re: A Tip (maybe new, maybe not) > > Go into the CF Admin and uncheck maintain database connections and your > database wont lock at all unless it's actively being accessed by CF. > > jon > Paul Giesenhagen wrote: > >>I don't know if any of you work with Access much as a database here and > > there, but I have been developing using an access database and had to upload > it to our servers after "looking" at the data or correcting the data as I > was writing scripts ..well as you all know it locks so you cannot FTP over > it once it has been accessed. > >>I would stop/start the cf service to get this to run, well it became a > > pain when my terminal window would timeout and I would have to logg back > into my server yadda yadda. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists