On Aug 28, 12:26 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote:
> On Aug 28, 11:16 am, bozon <cur...@crowson1.com> wrote:
>
> > On Aug 28, 10:37 am, bozon <cur...@crowson1.com> wrote:
> <SNIP>
> > We found that going to 16k helped performance on larger tables because
> > you don't have the remainder pages. On our star schema historical
> > reporting database where every table has large max page sizes we saved
> > almost 40% because every record wasn't really close to the maximum but
> > Informix would put each record on its own page if the max size was
> > greater than 2020.
>
> Actually, for variable sized rows, IDS will not place a row on a page
> if the remaining free space is less than the maximum size of a row.
> So if you have a row with a minimum size and maximum size such that
> the min plus the max is more than (pagesize - 36) only one row will be
> placed on a page.
>
> Art S. Kagel

Yep, which is what I was trying to say but didn't say it very well.