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
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
&
k.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 b
ECTED]]
> > 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 l
MAIL 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.
&g
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 Window
-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 rec
> 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
.
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 go
al 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 data
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
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 2a
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
> 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 gen
[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&
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 co
16 matches
Mail list logo
