| Subject | Re: [ib-support] How to menage the PAGE SIZE value ? |
|---|---|
| Author | Jason Chapman (JAC2) |
| Post date | 2003-02-06T01:28:45Z |
The larger the page size the more records / index nodes you can fit onto a
page.
Too small and you will make your larger rows spill onto more than one page
which is a disaster.
Typical values are 4K & 8K, 4K was popular as it matched the read profile of
NT and other OS's, i.e. the OS would read in 4K blocks, so having this in
sync with the DB made for best performance.
Too large a pagesize and you will be getting a lot of extra data from disk
when you select a specific row.
Bottom line is suck it and see + ensure that when you do DB stats, that
index depth <= 3.
HIH
JAC.
"Jakub Czy�kowski" <kuba@...> wrote in message
news:009f01c2cd76$72715460$0301a8c0@kuba...
page.
Too small and you will make your larger rows spill onto more than one page
which is a disaster.
Typical values are 4K & 8K, 4K was popular as it matched the read profile of
NT and other OS's, i.e. the OS would read in 4K blocks, so having this in
sync with the DB made for best performance.
Too large a pagesize and you will be getting a lot of extra data from disk
when you select a specific row.
Bottom line is suck it and see + ensure that when you do DB stats, that
index depth <= 3.
HIH
JAC.
"Jakub Czy�kowski" <kuba@...> wrote in message
news:009f01c2cd76$72715460$0301a8c0@kuba...
> Hello,What
> I tried to find any thing abount, how to menage the PAGE SIZE value.
> is importatnt, when I set it to the value 2K, 4K itp. What aboutperformance
> ? Etc. ...
>
> Can anyone explain me in 5 sentences, what I is the goal of managing this
> value ?
>
> Best regards
> Kuba
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>