How to free unused space (blanks)

Hi all,
My quesion is in 3 parts :

1- I would lik to know if there is another way to get back unused space except than doing a backup/restore on the database ?

2- Is there is a way to do this automatically (i.e. at night)

3- It seems (regarding used disk space) that Interbase server NEVER deletes rows. Do you think that deletes rows are only 'flaged' ? If yes, is there is a way to have a look on those deleted rows (and maybe unflag some of them)?


Who is Participating?
thegroupConnect With a Mentor Commented:
The mecanism that do that is backup/restore because of garbage collection.
You could try doing a select of all records to force the garbage collection.
The Interbase server reserves a space to work without overhead while inserting records, that space "reserved" remains in that state until a restore reclaims the storage unused by the database.

I don't know the use of flags or some way to "undelete" records.

You could use standard scheduling utilities to backup/restore the database at night.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.