Subject Re: how do i know what's the ideal page size for my database
Author martinknappe
--- In, "Adam" <s3057043@...> wrote:
> --- In, "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..
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?



It affects performance and file size. I
> would leave it at the default (4K) unless you have some specific
> reason to change it.
> Adam