db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hemant Gaur" <hg...@interwoven.com>
Subject RE: Derby DB Size
Date Tue, 19 Dec 2006 09:38:36 GMT
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: Knut.Hatlen@Sun.COM [mailto:Knut.Hatlen@Sun.COM] 
Sent: Tuesday, December 19, 2006 2:10 PM
To: Derby Discussion
Subject: Re: Derby DB Size

Hemant Gaur <hgaur@interwoven.com> 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


Mime
View raw message