Re: [Hsqldb-user] Are 'deleted' records still there? Can you purge?

[Fred T. <ft...@cl...>]

Yes, the objects are still there. Try "SHUTDOWN COMPACT" which will take a
while to finish and will copy all the existing records into the .script
file. Then start the database again, which will take a while. When it is
open, try "SHUTDOWN" (without compact). Check the .data file size and the
contents of the .script file at this point.

Fred
----- Original Message -----
From: "Wendy S" <wen...@co...>
To: <hsq...@so...>
Sent: Sunday, April 28, 2002 4:25 AM
Subject: [Hsqldb-user] Are 'deleted' records still there? Can you purge?



I have some players and game statistics stored in an hsqldb database.
The .data file is 4.5 megabytes!  I have been storing java objects
and deleting them, so I suspect that they're still _in_ there even
though they've been deleted.

How do I purge or pack this database so it only contains the
un-deleted records?

Or is my assumption wrong?  I just can't find that much data with
select statements.

--
Wendy in Chandler, AZ
wendywds * at % cox # dot ) net

_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user