RE: Memory problems
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. > > > > -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
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. > > > > -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. > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: Memory problems
That's what did us in too. They wanted a cool million to move our stuff over. We originally were running almost everything in Netscape LDAP and access, looked at both and SQL Server was the winner by many many dollars :) Tim Heald ACP/CCFD :) Application Development www.schoollink.net > -Original Message- > From: Jacob [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 5:05 PM > To: CF-Talk > Subject: RE: Memory problems > > > LOL... > > I agree. SQL server is one of the MS products I do like, which > is not that > many to begin with. > > We were going to jump from access to oracle. The price tag made > us change > our minds. > > At 05:01 PM 5/29/2002 -0400, you wrote: > >hehe: > > > > >I can sleep at nights with worry. > > > >Yeah I feel that way when I see MS on the cover too :) J/K I love SQL > >Server, wouldn't know what to do without it. > > > >Tim Heald > >ACP/CCFD :) > >Application Development > >www.schoollink.net > > > > > -----Original Message- > > > From: Jacob [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, May 29, 2002 4:57 PM > > > To: CF-Talk > > > Subject: Re: Memory problems > > > > > > > > > I agree. We had Access for our database and had nothing but > > > problems with > > > memory leaks. Had to reset the cold fusion service at least 4 to > > > 6 times a > > > day. > > > > > > Moved to SQL 7.0. What a different. Less headaches and resets. > > > Went from > > > 6 resets a day to maybe one every other week. Now with Windows > > > 2000, CF 5, > > > and SQL 2000. I can sleep at nights with worry. > > > > > > Sometime it is so quiet that I have to go to the server just > to make sure > > > it is still going. And it is. > > > > > > At 02:42 PM 5/29/2002 -0400, you wrote: > > > >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. > > > > > > > > > > > > > > > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: Memory problems
LOL... I agree. SQL server is one of the MS products I do like, which is not that many to begin with. We were going to jump from access to oracle. The price tag made us change our minds. At 05:01 PM 5/29/2002 -0400, you wrote: >hehe: > > >I can sleep at nights with worry. > >Yeah I feel that way when I see MS on the cover too :) J/K I love SQL >Server, wouldn't know what to do without it. > >Tim Heald >ACP/CCFD :) >Application Development >www.schoollink.net > > > -Original Message- > > From: Jacob [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 29, 2002 4:57 PM > > To: CF-Talk > > Subject: Re: Memory problems > > > > > > I agree. We had Access for our database and had nothing but > > problems with > > memory leaks. Had to reset the cold fusion service at least 4 to > > 6 times a > > day. > > > > Moved to SQL 7.0. What a different. Less headaches and resets. > > Went from > > 6 resets a day to maybe one every other week. Now with Windows > > 2000, CF 5, > > and SQL 2000. I can sleep at nights with worry. > > > > Sometime it is so quiet that I have to go to the server just to make sure > > it is still going. And it is. > > > > At 02:42 PM 5/29/2002 -0400, you wrote: > > >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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Memory problems
hehe: >I can sleep at nights with worry. Yeah I feel that way when I see MS on the cover too :) J/K I love SQL Server, wouldn't know what to do without it. Tim Heald ACP/CCFD :) Application Development www.schoollink.net > -Original Message- > From: Jacob [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 4:57 PM > To: CF-Talk > Subject: Re: Memory problems > > > I agree. We had Access for our database and had nothing but > problems with > memory leaks. Had to reset the cold fusion service at least 4 to > 6 times a > day. > > Moved to SQL 7.0. What a different. Less headaches and resets. > Went from > 6 resets a day to maybe one every other week. Now with Windows > 2000, CF 5, > and SQL 2000. I can sleep at nights with worry. > > Sometime it is so quiet that I have to go to the server just to make sure > it is still going. And it is. > > At 02:42 PM 5/29/2002 -0400, you wrote: > >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. > > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: Memory problems
I agree. We had Access for our database and had nothing but problems with memory leaks. Had to reset the cold fusion service at least 4 to 6 times a day. Moved to SQL 7.0. What a different. Less headaches and resets. Went from 6 resets a day to maybe one every other week. Now with Windows 2000, CF 5, and SQL 2000. I can sleep at nights with worry. Sometime it is so quiet that I have to go to the server just to make sure it is still going. And it is. At 02:42 PM 5/29/2002 -0400, you wrote: >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
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. -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
Re: Memory problems
> 1) How big are you access dbs? After a couple million records access tends > to go belly up... The biggest offender is 20 MB, with over 200 tables. Is that "a couple million records" across all tables? > 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 That's unchecked. But I don't think we'll be looking much further for 'help-Access-hobble-along' tips. We're overdue for a switch. -- Owen __ 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
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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: Memory problems
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 -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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Memory problems
Cycle.bat sets up the scheduler. Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 1: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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: Memory problems
Yup. It's called Cycle.bat Forgot about that... -Original Message- From: Wallick, Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:12 AM To: CF-Talk Subject: RE: Memory problems 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). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:10 PM To: CF-Talk Subject: RE: Memory problems That's a known "Feature" Schedule a task that restarts all the cold fusion services in the middle of the night using the command line net stop and net start commands. It's documented in the knowledge base somewhere deep in there, but it's pretty simple to get a batch file built to restart the cold fusion services... -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:04 AM To: CF-Talk Subject: Memory problems We've been having problems lately with our server running out of memory. I've gone over everything looking for unlocked session variables and cfx tags. We've increased the amount of RAM on the server. But still we're having problems, which seem manifest themselves first in errors generated by cfx tags and then in loss of connection to the database (Access). Does anyone have any advice on how to proceed to find out the cause of the problem? Somewhere I heard that ColdFusion server doesn't release memory once it uses it--that it holds on to it just in case. Is this true? -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: Memory problems
> We've been having problems lately with our server running out > of memory. > I've gone over everything looking for unlocked session > variables and cfx tags. We've increased the amount of RAM on > the server. But still we're having problems, which seem > manifest themselves first in errors generated by cfx tags and > then in loss of connection to the database (Access). > Does anyone have any advice on how to proceed to find out > the cause of the problem? Somewhere I heard that ColdFusion > server doesn't release memory once it uses it--that it holds > on to it just in case. > Is this true? The Access JET driver has a HORRIBLE memory leak... It's a "feature" of the ODBC driver... Solutions? Schedule a restart of the CF Service nightly Schedule a restart of the server nightly Don't use Access Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** __ 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
RE: Memory problems
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). Mike Wallick * Web Application Developer * [EMAIL PROTECTED] * 651.628.5377 * http://www.securecomputing.com/ -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 12:10 PM To: CF-Talk Subject: RE: Memory problems That's a known "Feature" Schedule a task that restarts all the cold fusion services in the middle of the night using the command line net stop and net start commands. It's documented in the knowledge base somewhere deep in there, but it's pretty simple to get a batch file built to restart the cold fusion services... -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:04 AM To: CF-Talk Subject: Memory problems We've been having problems lately with our server running out of memory. I've gone over everything looking for unlocked session variables and cfx tags. We've increased the amount of RAM on the server. But still we're having problems, which seem manifest themselves first in errors generated by cfx tags and then in loss of connection to the database (Access). Does anyone have any advice on how to proceed to find out the cause of the problem? Somewhere I heard that ColdFusion server doesn't release memory once it uses it--that it holds on to it just in case. Is this true? -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: Memory problems
That's a known "Feature" Schedule a task that restarts all the cold fusion services in the middle of the night using the command line net stop and net start commands. It's documented in the knowledge base somewhere deep in there, but it's pretty simple to get a batch file built to restart the cold fusion services... -Original Message- From: Owen Leonard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 10:04 AM To: CF-Talk Subject: Memory problems We've been having problems lately with our server running out of memory. I've gone over everything looking for unlocked session variables and cfx tags. We've increased the amount of RAM on the server. But still we're having problems, which seem manifest themselves first in errors generated by cfx tags and then in loss of connection to the database (Access). Does anyone have any advice on how to proceed to find out the cause of the problem? Somewhere I heard that ColdFusion server doesn't release memory once it uses it--that it holds on to it just in case. Is this true? -- Owen Athens County Library Services http://www.athenscounty.lib.oh.us __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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