Subject | Re: [ib-support] Page Sizes |
---|---|
Author | Frank Ingermann |
Post date | 2002-08-05T18:34:35Z |
Hi Richard,
Richard Pendered wrote:
from the doc on feature requests closed for FB1.0:
<quote>
446181
Enable support for 16kb pages
Feature - Added v1.0
Modify the engine and GBAK routines to allow for the an increased page size to
be specified beyond the current 8kb page size.
This will allow for a greater database size as well as can allow for the
developer to tune the database to meet their hardware environment.
</quote>
What's a bit confusing here is that the FirebirdRefGuide.pdf gives a different
answer: from the SLQ Statement reference on CREATE DATABASE:
<quote>
PAGE_SIZE [=] int
Size, in bytes, for database pages
int can be 1024 (default), 2048, 4096, or 8192
</quote>
so no mentioning there of 16k page size support - however i just tried it (with
Build 821) and it works fine by just specifying PAGE_SIZE=16384 in a CREATE
DATABASE statement, so the RefGuide must be wrong here...
regards & hth,
fingerman
--
-------------------------------------------------------------------------
when parsers parse, and compilers compile, then why don't objects object?
fingerbirdy - fingerman's door to Firebird
http://www.fingerbird.de
Richard Pendered wrote:
> Hi, just a quick and simple question:simple answer: YES!
> On the Win32 version 1 release, is 16k a valid page size ?
> TIA
> Rich P...
from the doc on feature requests closed for FB1.0:
<quote>
446181
Enable support for 16kb pages
Feature - Added v1.0
Modify the engine and GBAK routines to allow for the an increased page size to
be specified beyond the current 8kb page size.
This will allow for a greater database size as well as can allow for the
developer to tune the database to meet their hardware environment.
</quote>
What's a bit confusing here is that the FirebirdRefGuide.pdf gives a different
answer: from the SLQ Statement reference on CREATE DATABASE:
<quote>
PAGE_SIZE [=] int
Size, in bytes, for database pages
int can be 1024 (default), 2048, 4096, or 8192
</quote>
so no mentioning there of 16k page size support - however i just tried it (with
Build 821) and it works fine by just specifying PAGE_SIZE=16384 in a CREATE
DATABASE statement, so the RefGuide must be wrong here...
regards & hth,
fingerman
--
-------------------------------------------------------------------------
when parsers parse, and compilers compile, then why don't objects object?
fingerbirdy - fingerman's door to Firebird
http://www.fingerbird.de