Ann: So, if I am understanding well: the 80%-20% usage is not true?

Norman: Thank you very much, I had downloaded the 1.10 version.

Greetings.

Walter.

On Wed, May 1, 2013 at 11:37 AM, Ann Harrison <aharrison@...>wrote:

> **
>
>
> Norm,
>
>
> The default (ie, if you leave this parameter off the command line) is to
> > leave 20% of each page for future updates.
> >
>
> Unless the code has changed (for the worse) relatively recently, the amount
> of space left depends on the size of the uncompressed record data. When
> storing new records, Firebird normally leaves room for a fragmented record
> header (16 bytes, from memory) for each record on the page. So with a very
> tiny record, the page would be about half full (16 bytes free for each
> record
> plus its normal header). With very large records, the page might be over
> 95%
> full (leaving only 16 bytes of space).
>
>
> >
> > After the restore is completed, and as far as I am aware, the normal
> > 80-20% usage continues on new pages.
> >
> > Subject to the same caveat, once a database has been created with
> USE_ALL_SPACE, new records will be stored on pages without leaving
> extra room.
>
> Remember, gbak is nothing but an application that happens to know a
> lot about metadata and interdependencies. It has no special access to
> the database.
>
> Good luck,
>
> Ann
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]