Database size increase

Hi, I realize that both 3.1.7 and 3.2.11 are old hat by now but I just


upgraded to the latter and my db doubles in size. Is that normal?


Will it grow again in 5.0? I am using HSQLDB and the db is in-process,


which is why I am watching its size.





Thanks,





-- O.L.

Hi,





During table regeneration (at upgrade) most values in each row are updated.


To provide maximum processing speed, HSQLDB simply writes the records to anew location, and leave the old ones there inactivated as garbage.





There is a option however to compact the database on shutdown.


Use the SHUTDOWN COMPACT command for this.


Please see the HSQLDB documentation for details:


http://www.hsqldb.org/doc/guide/ch01.html#N101DB





It might be relevant to you that we also support Derby, which might be a better choice in some cases than HSQLDB.


http://db.apache.org/derby/





Best regards,





Szilard

Right you are. It's been over a year and I had forgotten about this. I will have to re-read my how-to notes... Thanks.