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.
>
>
> -
>
> *-USE_[ALL_SPACE]*
>
> 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]