Re: compress large database

You can use either SHUTDOWN COMPACT or CHECKPOINT DEFRAG to compact the
database file after removing several large tables.

Alternatively you could use TEXT tables for the raw import of the data.
As the data for these tables is stored separately in individual files,
you can later drop the tables and delete their files.

Fred

On Thu, Oct 22, 2015, at 20:34, Bayless Kirtley wrote:
> Is there a way to compress a large database after removing several
> tables? I am converting an Access database to HSQL and Java and have
> several large tables for raw import of the Access tables. After
> massaging them into final form, I drop the raw tables but the size of
> the database files does not seem to notice that. It stays about double
> the size it needs to be.
>
> Thanks Bayless
>
> ----------------------------------------------------------------------
> --------
> _________________________________________________
> Hsqldb-user mailing list [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user