| Subject | Re: how do i know what's the ideal page size for my database |
|---|---|
| Author | martinknappe |
| Post date | 2006-05-27T13:11:59Z |
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
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?
thanx,
martin
It affects performance and file size. I
>Ok, I did that. When I change the page size from 4kbyte to 16 kbyte my
> --- In firebird-support@yahoogroups.com, "martinknappe" <martin@>
> wrote:
> >
> > simple question; just like that ;)
>
> Mostly by experimentation.
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?
thanx,
martin
It affects performance and file size. I
> would leave it at the default (4K) unless you have some specific
> reason to change it.
>
> Adam
>