Subject | Re: [firebird-support] Database-Size and average fill of datapages |
---|---|
Author | Ann W. Harrison |
Post date | 2004-12-07T19:21:43Z |
>At 06:10 AM 12/7/2004, Josef Gschwendtner wrote:At 02:07 PM 12/7/2004, Ann W. Harrison wrote:
>
> >Why is the average fill for data-pages not higher then 58%??? Can this
> >be tuned?
>By default, the system leave space <blah blah...>That behavior is controlled by the configuration file and
should be turned off for an archival database. For a
database that will see update and delete activity, leaving
space on page is good for performance because it increases
the chances that all versions of a record will be read at
once.
Regards,
Ann