Hello. My objectDB had over 100 million records. I have removed 100,000 records in that DB and the size does not decrease. In fact it keeps growing as records decrease. Is that supposed to happen?
FYI: The DB is client server mode, and it is not being restarted as records reduce, as it is live in production.
I do an hourly backup and the backup file is not any smaller(it gets bigger) each hour as record count reduces.
When objects are removed sections of the database file are marked as free, and can be reused later when new objects are persisted. However, the size of the database file is not reduced. So this is a normal behaviour. Currently, the way to reduce the size of a database is to use the Doctor utility, creating a new (smaller) copy of an existing database file.
Thanks. So even though the DB is not corrupt I will run it like I'm repairing the DB and generate the new file, then replace the current DB file with the new one. Is that correct?
I'm assuming Dr DB has to be run when the DB is shut down, right?
Yes, you described it correctly.