Subject Re: What is the optimum pageSize?
Author
Post date 2019-11-14T22:47:22Z
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...


Steve Naidamast
Sr. Software Engineer