Many thanks Knut, I was able to get all the files shrinked using this. So this has to be done manually every time using tht ij tool, else the DB files will keep on growing or do we have some setting in derby which can perform this cleanUP.
Regards, Hemant Gaur -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 2:10 PM To: Derby Discussion Subject: Re: Derby DB Size Hemant Gaur <[EMAIL PROTECTED]> writes: > Hi, > I am using the OpenJMS with derby DB. I ran some performance tests and > at the end of it I found DB folder size in 7.1 GB. The opemJMS clears > the tables after the messages are delivered. I verified that the tables > don't have much data using in. Why then there are large sized .dat files > in the database folder? Is there any DB configuration parameter which > can be used to limit this size and hence the derby does the clean up > before the next insertion? Hi Hemant, It is possible to compress the tables to reclaim unused space. See http://db.apache.org/derby/docs/10.2/ref/rrefaltertablecompress.html for details. -- Knut Anders
