cfinsert and cfupdate can screw memory up in a hurry too! DRE -----Original Message----- From: David Hannum (Ohio University) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 9:40 PM To: CF-Talk Subject: Re: Memory problems
The point I was making was not in defense of Access. I know Owen and what he's doing. My point was that I don't think his files are nearly as big as Michaels archives, so I don't think file size is the problem. The drivers may be. The install may be hosed as well. I agree - I'd get out of Access ASAP too, but until he can, there are other things he can try. Dave ----- Original Message ----- From: "Rob Baxter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 3:38 PM Subject: RE: Memory problems > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
