Are you repopulating all the tables in the database? If so, it might be easier to
just replace the old version with a clean empty version instead of deleting the
content and adding it again. I compact one of our databases weekly, but haven't
found a way to do it automatically. However, in my case, I'm in the database
regularly anyhow, so it's not a problem to do it manually.
Bruce Young wrote:
> I do a lot of DB work with Cold Fusion. One of the DB's is deleted and
> repopulated each day from another source. I use the CF "transaction" tag to
> make sure that it completes everything properly before deleting the old
> data.
>
> This is an MS Access DB on NT4 using CF. (please... beg... no Linux references)
>
> However the DB has grown to 41Mb but when compacted is only 172kb! Is there
> anything I can do in a CF script or Perl to keep it in a more compact form?
> I don't want to change the basic system... I'm just after info on how to
> keep the DB size under control automatically.
--
Making the Web Work for You (tm)
Susan Duncan ([EMAIL PROTECTED]) Voice: (613) 744-3283
Director, Internet Development Fax: (613) 744-1825
http://www.malico.com Toll Free: (877) WEB-PROS
http://www.OttawaWEB.COM
MALICO - Graphic Design and Internet Development
Founders: Ottawa-Hull Chapter-Int'l Webmasters Association
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
