RE: Database doesn't shrink when data are deleted

Thank you very much for your answer.

I personally would love to see this fixed too.

Le mercredi 30 mars 2005 à 14:58 -0600, Jelai Wang a écrit :
> 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]
> 
> 



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