[AccessD] Compression slows down MDB

I would bet it is taking a long time to expand the file to hold the updates.  The bigger size is 
obviously mostly empty so if it is uncompressed it may be using empty space in the db file.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 1/27/2012 12:11 PM, Edward Zuris wrote:
>
>   Looking at MSFT's web site I get the impression
>   that repair and compression of your MDB file is
>   a good thing.
>
>   However. . .
>
>   Has anyone had the experience of doing a compress
>   and your MsAccess application slowed way down ?
>
>   At 170 megabytes in size, it takes 31 minutes to do
>   a days worth of updates.  At 850 megabytes it takes
>   just 8 minutes.
>
>   BTW, this happens on W2K 32bit Pro with Office 2000,
>   and Win-7 64bit Pro, using Access 2003 32bit, using
>   access 2000 file structures.
>
>   The application didn't change that behavior when
>   converting every thing over to Access 2003 file
>   structures.
>
>   Any ideas ?
>
>   Thanks.
>
>   Sincerely,
>   Ed Zuris.
>
>