AW: Database doesn't shrink when data are deleted

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

-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:[email protected]] Im Auftrag von Gregoire
Dubois
Gesendet: Mittwoch, 30. März 2005 12:28
An: [email protected]
Betreff: Database doesn't shrink when data are deleted


Hi all,

I am using Mckoi 1.0.3

I store a lot of binary files in the database using BLOB tables. But
when I delete the files from the database, the file BlobStore.koi
doesn't shrink. And using COMPACT TABLE does nothing more.

Just now , I have deleted all the files of the database. But, there are
still 2 files that remain big : BlobStore.001 and BlobStore.koi

BlobStore.001 : 820.9 MB
BlobStore.koi : 1.0 GB

Why are those files remaining at this size? Is that a bug?

Thank you very much for any help !
Grégoire



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



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