Subject | Re: FireBird 1.5 Benchmark |
---|---|
Author | Alexander V.Nevsky |
Post date | 2003-11-18T11:32:17Z |
--- In firebird-support@yahoogroups.com, "Alfred Seetoh"
<cwseetoh@s...> wrote:
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.
<cwseetoh@s...> wrote:
> Forced Writes are enabled for both databases. However I do noticeCertainly. Look at
> 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?
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.