I’m using derby in a embedded mode and experiencing the increasing size of db files. The .dat files in the seg0 directory eating up my disk space!
I searched a lot about how to avoid the db file becoming huge but only one solution described in manual: Reclaiming unused space.
Is there really no other way? How to limit the size of db file after large amounts of insert and delete operation?