Are they storing client variables in the DB?
Dan Phillips
www.CFXHosting.com
1-866-239-4678
[EMAIL PROTECTED]
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to
:45 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB
Are they storing client variables in the DB?
Dan Phillips
www.CFXHosting.com
1-866-239-4678
[EMAIL PROTECTED]
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17
Sounds like it might be client variables in the DB - that's the first
thing I'd check.
- Jim
Mark W. Breneman wrote:
I just got back from a client site and they are running CF5 and MS
access.
The problem is that the MSAccess file grows at least 5 MB per min. thus
filling the hard disk. I
Hm...did you see anything in the DB when you had it open?
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:49 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB
No, we are only using session vars
, 2003 3:53 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB
Hm...did you see anything in the DB when you had it open?
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:49 PM
To: CF-Talk
Subject: RE: Help
What does the application do? Are there tons of inserts and deletes?
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 12:45 PM
To: CF-Talk
Subject: Help: CF5 is making access file grow to 2GB
I just got back from a client
that is on the low
side) it would only be 20 hours till it built the 2 GB file.
Thanks
MB
-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 3:53 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB
Hm
Are you are on CF5 or MX?
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 5:18 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB
I am sorry! The site uses menu monger pro and MM pro does use client
vars.
So
Has anyone seen this before?
This will happen if you make frequent updates by deleting records and rewriting them
with different data. I know it is easier, but it leaves plenty of holes in the
database and every new record takes new space.
One way of avoiding this is to make sure you reuse and
CF5 (as in the subject :-)) I've had a long day too.
MB
-Original Message-
From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:18 PM
To: CF-Talk
Subject: RE: Help: CF5 is making access file grow to 2GB
Are you are on CF5 or MX
I had a similar issue, but quite as bad, but an MS access db would grow to
2GB in about a week or less depending on the activity.
I solved (if you call it that) the issue by doing an automatice compression
of the db everynight.
Let me know and I will email you the code off list.
I got the
Yes please, it may be a good short term fix. Or long term...
You can mail it to:
[EMAIL PROTECTED]
-Original Message-
From: Bruce, Rodney S HQISEC/Veridian IT Services
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:42 PM
To: CF-Talk
Subject: RE: Help: CF5 is making
Bruce, Rodney S HQISEC/Veridian IT Services wrote:
I had a similar issue, but quite as bad, but an MS access db would grow to
2GB in about a week or less depending on the activity.
You might want to check if your client variables have global
updates enabled, they can add quite a bit of
13 matches
Mail list logo