--- In firebird-support@yahoogroups.com, "martinknappe" <martin@...>
wrote:

>
> --- In firebird-support@yahoogroups.com, "Adam" <s3057043@> wrote:
> >
> > --- In firebird-support@yahoogroups.com, "martinknappe" <martin@>
> > wrote:
> > >
> > > simple question; just like that ;)
> >
> > Mostly by experimentation.
>
> Ok, I did that. When I change the page size from 4kbyte to 16 kbyte my
> queries execute *way faster. but what's all the fuss about? just to
> make myself some idea of how these pages are physically represented in
> the database and see whether there's a way to speed things up even

more..

These may help:

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

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

A higher page size allows for a greater density of data on a single
page (obviously). Buffers etc are measured in pages, so perhaps the
performance increase has more to do with the fact your cahce will be 4
times the size with a 16K pagesize.

> is there a reason why ibexpert offers me page sizes of 4, 8 and 16
> kbyte or would it be equally meaningful to change the page size in the
> script to, say 3 kbyte or anything else?

Looks suspiciously like powers of 2 ;)

Adam