Database doesn't shrink when data are deleted

Gregoire Dubois <[email protected]> Wed, 30 Mar 2005 12:28:19 +0200
Newsgroups gmane.comp.db.mckoi
Message-ID <1112178500.3292.16.camel@Greg>
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]