RE: Compressing DB while other process is using it

2008-02-18 Thread indianiec
Thanks guys, I got some stuff to think about now :) Cheers -- View this message in context: http://www.nabble.com/Compressing-DB-while-other-process-is-using-it-tp15483146p15541527.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Compressing DB while other process is using it

2008-02-15 Thread Stanley Bradbury
indianiec wrote: All, I encountered a big problem. We recently released new software and have big problems with disk space. When we developed it we did not notice that you need to reclaim space after you delete rows. We need to find a solution to that problem without releasing new software versi

RE: Compressing DB while other process is using it

2008-02-14 Thread Jim Newsham
Although Derby doesn't immediately release space freed up by deleted records, it will eventually re-use that space (when new records are inserted). So the issue that you have is really only a problem if you are deleting a large number of records at once and you need that space back immediately.