Re: [Hsqldb-user] Huge Data files

[fredt <fr...@us...>]

You should perform a SHUTDOWN COMPACT on the database with cached data to 
reach its minimum size.

Usaully, the size of the .data file with cached tables is similar to that of 
the .script file with memory tables.

The size of the cached table .data file increases when there are more 
indexes on the tables.

Fred


----- Original Message ----- 
From: "Marc Ravensbergen" <mar...@gm...>
To: "HSQLdb user discussions" <hsq...@li...>
Sent: 31 July 2007 14:51
Subject: [Hsqldb-user] Huge Data files


Hi, I have been using the default memory table type for my tables, but while
importing real data (from a different database) into my hsql database, I
noticed that I would run out of memory because the database is quite large.


I created two sample databases, one using memory tables, and the other using
cached tables; these two databases contain the exact data.

The memory database is 2.6 MB,
The cached database is 9.1 MB

Is that normal, that the cached database (on disk) is so much larger then 
the
memory only database?

The other thing I would like to know... is there anything I can do to reduce
database size (by size, I mean the size of the files on disk when the
database is closed)? Is there anything that really affects the size of the
database (indexes etc.)?

Thanks,
Marc

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user