I do a ton o fwork in CF...let me browse my noggin and get back to you on
this.
Eric J Hoffman
Director of Internet Initiatives
Meagher & Geer, PLLP
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce
Young
Sent: Sunday, November 08, 1998 5:10 PM
To: [EMAIL PROTECTED]
Subject: WC:>: DB compaction
Hi
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.
thanks
Bruce
____________________________________________________________________
--------------------------------------------------------------------
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.
---------------------------------------------------------------------
____________________________________________________________________
--------------------------------------------------------------------
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.
---------------------------------------------------------------------
