I was curious if you could assist me with a challenge we are having with our objectdb database. Our odb files are about 50Gb in size and are written to about a million times a day with both adds and updates. This is creating a lot of unused space in the database that we are wanting to reclaim. Other database vendors provide a vacuum process to allow dumping a database to a flat file (basically a sql dump) and reload. Is there a capability in ObjectDb to provide a vacuum? The online backup feature appears to copy the dead space as well so isn't performing the vacuum.
If there is no way to do this other than manually implementing code to read, delete, and write to a new odb, is there an algorithim that you could provide that plays to ObjectDb's strength. We have half a Tb of data to clean up and want to do this as efficiently as possible.
Thanks!