Two questions.. 1) How big are you access dbs? After a couple million records access tends to go belly up...
2) are you using connection pooling? Access memory leaks will kill you if you have the "maintain db connectoins" box checked in the ODBC administrator </rob> -----Original Message----- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:43 PM To: CF-Talk 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. ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
