Subject Re: [ib-support] Reserve Page Space?
Author Ann W. Harrison
At 01:44 PM 1/10/2003 -0600, Don Gollahon wrote:
>I can't find anything on the setting called "Reserve Page Space". What is
>it for? I've noticed it is off on most of our databases but on for a couple
>of them.

Normally as records are stored a portion of each page is
reserved for back versions. Sixteen bytes are reserved
for each record stored, so the percentage of space depends
on the compressed size of the records.

If the database is primarily archival and will not be
updated, there is no reason to reserve space for back
versions.


Regards,

Ann
www.ibphoenix.com
We have answers.