Subject Re: FireBird 1.5 Benchmark
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Alfred Seetoh"
<cwseetoh@s...> wrote:
> Forced Writes are enabled for both databases. However I do notice
> some differences between the 2 of them.
>
> Config FB 1.0 FB 1.5
> ====== ====== ======
> Page Size 8192 1024
> ODS Version 10.0 10.1
> Buffers KB 16384 2048
>
> Could the difference page size and buffers cause the difference in
> speed?

Certainly. Look at

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_conf_opt

Article is rather old, so check Release Notes of used
version for description of new configuration parameters.
Recommendation for most general case - make page size equal to disk
cluster size used in OS. About cache buffers - for Superserver about
10000, for Classic 75. For database with complex metadata structure on
Classic it can be useful to tune this experimentally increasing and
checking performance.

Best regards,
Alexander.