Hi Dmitry, > Out of curiosity, what was your rationale for the page size change? This is > not something I'd recommend without serious reasons behind
We change to 32KB because of an old publication from Josh Hartmann: "Database Page Size The default page size is 4KB. You can check to see what your database is using by running the gstat command. gstat -h <path to DB> We found that increasing our page size to 16KB increased performance a lot. (Almost double, again) In order to do this, the database needs to have a backup/restore done on it. When restoring, specify the -p switch and set it to 16384." We can confirm this from 4KB to 16KB. The we assume the same for the switch from 16KB to 32KB. The result is mixed up (we compare both ) Complex Querys with several records in the resultset are faster with 32 KB. Simple querys that select only one record by an uniqe key are a Little bit faster im 16KB. We have a lot of such query. If we sum all the query time 32 KB is faster. At the time we don’t Tweak the FB 4 Environment, we don’t play with Cache Setting, we only compare FB 2.5 and FB 4 in identical test environment. We would be happy to receive tips on how to optimize the FB4 environment With best regards Nils Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
