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 <k...@ibase.ru> 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] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
