Subject Re: [firebird-support] Re: use of -USE_ALL_SPACE
Author Nick Upson
As I understand this now, restoring the database with use_all_space will
store the data as compactly as possible, then I do "gfix -use reserve" and
all subsequent changes will use the 80/20 rules for where the data goes


On 4 May 2013 17:43, Dmitry Kuzmenko <kdv@...> wrote:

> **
>
>
> Hello, Nick!
>
> Thursday, May 2, 2013, 6:33:15 PM, you wrote:
>
> NU> as I now understand it, if I restore the database with -USE_ALL_SPACE &
> NU> then do gfix -use reserve I will have a database which has all the
> static
> NU> data on full pages and the data that does change will quickly go back
> to
> NU> the 80/20 page usage. Something like 90% is static so I'm hoping this
> will
>
> No. I wonder where these rumours or false guesses comes from.
> No_reserve is a global switch, and after it is set, FB will not
> reserve space anymore at data pages.
>
> Gbak, as Ann said (and I says it constantly), is an ordinal
> application that inserts data to DB as any other application do.
> No magic, at all.
>
> For example, InterBase XE have new behavior and options to
> 1. change no_reserve option as ALTER DATABASE at runtime
> 2. change no_reserve option for selected tables.
>
> In Firebird, to set this option off, you may only use gfix, once,
> for all the database. And you can't do it during gbak.
>
> So, currently, this option in FB is only useful for read-only
> databases. That's it. Because option cannot be set for selected
> tables, only for the whole database.
>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>
>
>



--
Nick Upson, Telensa Ltd


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