db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Does a database shrink?
Date Thu, 04 Feb 2010 23:48:35 GMT
a derby table/index will not automatically shrink ever.  Deleted row 
space can
be used automatically by subsequent inserts or updates to the same
table or index.  Space is returned to the operating system when a table 
or index is dropped.
One needs to
call the compress routines by hand to get a db to shrink.

David Van Couvering wrote:
> If I delete a bunch of rows from my database, does the size of the 
> database shrink, or does it keep the space it has allocated once I grow 
> to a certain size?
> Thanks!
> David
> -- 
> David W. Van Couvering
> http://www.linkedin.com/in/davidvc
> http://davidvancouvering.blogspot.com
> http://twitter.com/dcouvering

View raw message