Re: AW: Database doesn't shrink when data are deleted

Hi,

Yes, this is correct.  COMPACT TABLE will shrink the file size of data 
stored in tables, however it does not work on the BlobStore which stores 
the cells of large data.  This is an issue that will be addressed.

Toby.


Klaudio Kaiser wrote:

> Hi,
> 
> "compact table" DOES shrink a table (or all physical files representing
> tables -
> normally the physical file representing a table has the same name as the
> table
> in the proper create table sql-statement). But as far as i know blobs are
> stored
> in one or more separate file(s) - BlobStore.koi (.001, ...). The blob store
> itself cannot be shrinked but when blob data is deleted the physical file
> space
> in BlobStore.koi is reused before the file is appended - search the mckoi
> mail
> archive for this topic.
> 
> Regards
>   Klaudio



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]