Subject Re: [firebird-support] Re: Fill ratio when doing a restore
Author Ann W. Harrison
Christian Kaufmann wrote:
> The data fields of my record are two smallint and two integer fields.
> So this is 12 bytes. With your explanation, a fill ratio of 59% is
> fine in this case.
> But because this table will grow in the future and existing records
> will change very rarely, my question remains, if I should restore with
> -use_all_space.

In this case, I would use that switch. The reserved space is used
only for modified and deleted records. If there is no space on page
when a modification or delete is done, Firebird will move the back
version to a different page. That's expensive, but not nearly so
expensive as having all pages half filled.