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.
Bruce, that seems like a *very* dramatic difference: from 41mb to 172k! I
would check deeper into *how* the CFTRANSACTION tags does it's business.
Perhaps it's creating some temporary stuff in the db that isn't being
properly purged when the transaction is done? I'd look through the Allaire
developer forum to see if there's any mention.
I've noticed that Access will grow in size during development *inside* the
Access GUI: as forms, queries, reports, etc are developed (and sometimes
just thrown away) stuff seems to linger in the db until it is compressed.
I'm not sure why this happens, but have just taken it for granted...since
it's been the case since v1 (as I remember it). I usually just compress
regularly during development.
Perhaps the CFTRANSACTION tag is leaving temporary stuff in the .mdb file,
too? One thing you could do is open your uncompressed .mdb file in Access,
click tools/options/view, then put a checkmark in "Show hidden objects" and
"Show system objects". Hit OK, then take a look at the tables in the .mdb
... see if there seem to be any extraneous leftovers from CF transactions.
This is just a hunch...it's somewhere I'd look to try to figure out why the
extra space is collecting.
BTW, if you don't find an answer in the Allaire developer forum, and you're
not used to using it, I've found that almost all questions are answered by
"someone" rather rapidly.
BTW2: I'd be interested in hearing what you discover, since I am currently
working on a project that will use CFTRANSACTION.
Thanks,
Jack
____________________________________________________________________
--------------------------------------------------------------------
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.
---------------------------------------------------------------------
