Subject | Database Statistics |
---|---|
Author | Alan McDonald |
Post date | 2003-07-05T00:30:17Z |
I recently had reason to track down why a database was bloating up very
quickly... it took some time to find the reason being binary blobs. The
current statistics show record numbers and kb per table but it appears that
blobs are not counted into this stat. IBexpert [rovides a nice summary of
the stats per table etc. Is there a way of extracting blob sizes? or
including blob disk storage space inthe relative table?
Specifically, I have one table in my db with two binary blob fields. The
summary shoed what I expected to see as a total storage space of about 6Mb
for the db but the db was 56Mb. I finally tracked it to the presence of 27x
1.7mb bitmaps which do not show on the stats anywhere.
Alan
quickly... it took some time to find the reason being binary blobs. The
current statistics show record numbers and kb per table but it appears that
blobs are not counted into this stat. IBexpert [rovides a nice summary of
the stats per table etc. Is there a way of extracting blob sizes? or
including blob disk storage space inthe relative table?
Specifically, I have one table in my db with two binary blob fields. The
summary shoed what I expected to see as a total storage space of about 6Mb
for the db but the db was 56Mb. I finally tracked it to the presence of 27x
1.7mb bitmaps which do not show on the stats anywhere.
Alan