RE: Database doesn't shrink when data are deleted

I can confirm this behavior.  I use the BLOB data type to store ~ 8 GB of
data in one of my applications, I've since trimmed it down, but it still
takes the same space even after COMPACT TABLE.

IIRC from the mailing list archives, this issue has already been discussed
in another thread (although I can't find it at a glance), and if I'm not
mistaken is a known issue that Toby is working on.  I personally would love
to see this fixed.

This behavior was observed in both mckoi 1.0.3 and 1.0.2 on Linux + JDK
1.4.2.

Hope this helps.

Jelai

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Gregoire
Dubois
Sent: Wednesday, March 30, 2005 2:59 PM
To: [email protected]
Subject: RE: Database doesn't shrink when data are deleted


I thought so, as that is what is written in the documentation. But I can't
make it work... 

Would anybody have tried "COMPACT TABLE" with BLOB or any other type? Am I
the only one to have this problem?

I'm using Mckoi under Linux Fedora Core 3... If it can be of any help.

Thank you very much. 

Le mercredi 30 mars 2005 à 09:14 -0800, James a écrit :
> Doesn't 'COMPACT TABLE' clean up disk space used?
>    http://mckoi.com/database/SQLSyntax.html#9
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------
> 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]


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