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. ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
