Comparing Databases Before/After Compact & Repair

T

Tony

Hi All,

Does anyone have any suggestions on how to compare a database to a copy of
itself, compacted vs. uncompacted? I have a vendors product that is
currently balooning their included .mdb. I've got a copy of the original
(116MB) and a copy I compacted (1.6MB). I'd like to see if I can identify
which objects might be at issue.

Any suggestions are definitely appreciated.

Ciao
 
T

Tom van Stiphout

On Thu, 8 Nov 2007 12:05:51 -0600, "Tony" <|[email protected]|>
wrote:

There are no tools that I know of that can report the size of
uncompacted objects.

Typically the bloat is in tables where many records are repeatedly
added and removed, for example temp tables and report tables.

Fortunately you can buy 116GB hard drives for less than USD116, so it
may not be worth worrying too much about.

-Tom.
 
Top