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