Doesn't the page size definition as per a database depend on one designs their
database tables and how such tables will be used?
In any event, here is what the Developer Guide for version 3.0 of Firebird
states...
The actively supported versions of Firebird support the following page sizes:
4096, 8192 and 16384. The page
size of 8192 is good for most cases.
This is rather ambiguous for most database developers looking to optimize
their databases. So a link to the IB-Experts site provides more guidelines on
selecting database, page sizes. The information is somewhat dated as to the
references to the earlier Firebird versions but the design information is
credible as it relaters fairly standardized design paradigms in the industry...
https://www.ibexpert.net/ibe/index.php?n=Doc.PageSize
https://www.ibexpert.net/ibe/index.php?n=Doc.PageSize
Steve Naidamast
Sr. Software Engineer
