Paul Taylor <[email protected]> writes: > HI, I use derby in embedded mode, I let the user specify a maxmium > size for the derby database files, my program monitors this and if it > goes over the size I use SQL to delete records that are no longer > necessary in the hope of shrinking the database files size, but it > doesn't, how can I force Derby to shrink back down ?
Hi Paul, The database files won't shrink unless you compress the tables. http://db.apache.org/derby/docs/10.6/ref/rrefaltertablecompress.html http://db.apache.org/derby/docs/10.6/ref/rrefproceduresinplacecompress.html Hope this helps, -- Knut Anders
