Help: CF5 is making access file grow to 2GB
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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137376 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137378 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3: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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137381 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: Help: CF5 is making access file grow to 2GB
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 was able to do a simple compact with access >and the file shrunk from 2 GB to 5 MB, but soon after started to grow >again. > >Has anyone seen this before? > >I assume that since I can shrink the database to 5 MB then it is not >real data that is taking up the 2gb of space. > >Anyone have any ideas? > >I found that if reset CF it took about 15mins for the growing to start. > >Thanks > >Mark W. Breneman >-Cold Fusion Developer >-Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137383 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
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: CF5 is making access file grow to 2GB No, we are only using session vars. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3: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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137387 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
Dan, Nothing out of the ordinary. I have RDS access the client's server. I am downloading a back up of the file I made a few min ago. I'll take a 2nd look. 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...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. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3: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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137389 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
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 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 was able to do a simple compact with access > and the file shrunk from 2 GB to 5 MB, but soon after started to grow > again. > > Has anyone seen this before? > > I assume that since I can shrink the database to 5 MB then it is not > real data that is taking up the 2gb of space. > > Anyone have any ideas? > > I found that if reset CF it took about 15mins for the growing to start. > > Thanks > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137391 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
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 yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think 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...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. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3: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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137393 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Help: CF5 is making access file grow to 2GB
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 yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think 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...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. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3: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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137395 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
Re: Help: CF5 is making access file grow to 2GB
>>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 update all records you can instead of deleting them. It is more work however. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137396 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Help: CF5 is making access file grow to 2GB
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? -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 yes, it is using client vars. Now what? Why did this start to mega bloat now? The site has been up and running as is for about a month with out problems. At the rate of an estimated 100MB per hour (I think 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...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. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 3: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, 2003 4:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137397 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Help: CF5 is making access file grow to 2GB
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 origanal code from Jochem, so he might have a more updated version as well. -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137400 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
RE: Help: CF5 is making access file grow to 2GB
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 access file grow to 2GB 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 origanal code from Jochem, so he might have a more updated version as well. -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:45 PM To: CF-Talk Subject: Help: CF5 is making access file grow to 2GB 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 was able to do a simple compact with access and the file shrunk from 2 GB to 5 MB, but soon after started to grow again. Has anyone seen this before? I assume that since I can shrink the database to 5 MB then it is not real data that is taking up the 2gb of space. Anyone have any ideas? I found that if reset CF it took about 15mins for the growing to start. Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137401 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Help: CF5 is making access file grow to 2GB
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 load. > 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 origanal code from Jochem, so he might have a more updated version > as well. I received some patches (for password protected databases), but haven't gotten around testing them yet. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137404 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com