RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Dan Phillips \(CFXHosting.com\)
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
: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

Re: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Jim Campbell
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Dan Phillips \(CFXHosting.com\)
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
, 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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Craig Fisher
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Dan Phillips \(CFXHosting.com\)
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

Re: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Claude Schneegans
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Bruce, Rodney S HQISEC/Veridian IT Services
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

RE: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Mark W. Breneman
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

Re: Help: CF5 is making access file grow to 2GB

2003-09-17 Thread Jochem van Dieten
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