Well, why do you think he's moving the list archive out of Access? Up to a certain amount of traffic/data MS Access is a decent solution. After that it's a 'disaster waiting to happen' to quote Michael himself.
I'd definetely begin considering other alternatives, ASAP. </rob> -----Original Message----- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 3:09 PM To: CF-Talk Subject: Re: Memory problems Owen, I doubt that the size of your files is the problem. Michael D. runs the CF-talk list with an Access database (or did until just recently). Have you got the latest MS Jet drivers? Access 2000 is much more stout than 97. Perhaps the latest ODBC drivers would be a quick short term fix. Dave ----- Original Message ----- From: "Owen Leonard" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 2:42 PM Subject: Re: Memory problems So, the consensus is Access is the problem! I wonder if the memory problems have gotten worse in the past couple of months because of the growing size of the database? > I think in the cfusion\bin directory there is a batch file provided that > sets up your scheduler to restart cf services at 2am (or so). So running Cycle.bat sets up the scheduler? Or do I need to schedule Cycle.bat to be run? I guess conversion to MySQL is now on the top of the pile after vacation. -- Owen ---- > We've been having problems lately with our server running out of memory. ______________________________________________________________________ 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
