[AccessD] Back End Bloat - Revisited

Hi, Susan,

That's probably not the source of my trouble.  None of the data from those files is being pushed directly into the back end that is giving me trouble.  That BE holds meta data derived from data in the text files.  IOW, system logic eveluates the nature of the data and creates records in several tables based on what it finds there, but does not import from those files directly.  In fact the BE that DOES hold data that comes directly from the text files has no bloat problem, despite the fact that it receives WAY more data into its tables than the problem DB.

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, January 02, 2009 6:23 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Back End Bloat - Revisited

> <<The app can run for several complete processing cycles (each cycle
> involves the collection of data from text files produced by other systems)
> with no weight gain - NONE, and then it will suddenly leap in size by as
> much as 100 MB.  Within a couple of hours, it will have grown from about
> 150
> MB to well over 500 MB.  Then within 24 hours, it will have grown to a
> size
> approaching 2 GB, requiring a compact.  The last time I ran through this
> routine, the compacted size was just 8K larger than the size it started
> out
> at before it started growing.>>
>
>  Are you updating existing records or just appending?  And what version of
> Access/JET is this?

=====I'm curious if the original source files are coming from a different
source -- since you say "other systems" -- I'm wondering if the source files
might be your culprit in the form of phantom characters. As a test, you
might watch to see if the incoming source is always the same. If it is,
clean the data up in Excel before importing into Access.

Susan H.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


This e-mail may contain Sprint Nextel Company proprietary information intended for the sole use of the recipient(s). Any use by others is prohibited. If you are not the intended recipient, please contact the sender and delete all copies of the message.