db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Derby DB Size
Date Tue, 19 Dec 2006 08:40:15 GMT
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