Subject | RE: [firebird-support] RE: Stored Proc optimisation advice |
---|---|
Author | Maya Opperman |
Post date | 2012-09-14T10:14:19Z |
>>>> Attributes force write, no reserveOK, I figured out what happened.
>>> Having "no reserve" isn't a good option for a regular read/write production database, because this basically prevents having back record versions on the same page as the primary record version, thus additional page reads are necessary.
>
>> Thanks Thomas!
>
If you restore just once using 'use all space', then the next time you backup/restore, it remembers that setting!
(I'm using FIBPlus's components, but I presume GBAK will do the same thing)
So now, I'm going to have to make sure I run GFIX after every restore, where 'use all space' has not been specified, to make sure it doesn't stay in that mode.