Not having to re-establish the connections repeatedly helps with performance.
-----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:02 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) 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. > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
