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.
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
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.