Subject Re: use of -USE_ALL_SPACE
Author Nick Upson
as I now understand it, if I restore the database with -USE_ALL_SPACE &
then do gfix -use reserve I will have a database which has all the static
data on full pages and the data that does change will quickly go back to
the 80/20 page usage. Something like 90% is static so I'm hoping this will
give me some improved performance on queries against the static data.

On 1 May 2013 15:25, Nick Upson <nu@...> wrote:

> H
> i,
> firebird 2.1.5 on centos,
> does this option just restore the data using 100% of each page and then
> the database works as normal, with 80% usage or does it restore the data to
> 100% and then force all subsequent use of the database to work at 100%
> usage as well. I can read the extract below either way.
> -
> This switch forces the restore to use 100% of each database page and
> thus not leave room for changes. By default, 80% of a page is used and 20%
> kept for changes. This switch is likely to be only of practical use where
> the database is created and used in read-only mode.
> --
> Nick Upson, Telensa Ltd

Nick Upson, Telensa Ltd

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