RESIDENT and BUFFERPOOL

Posted in 2005

David E. Grove — Fri, 1 Apr 2005 08:09:07 -0900 — source: Usenet: comp.databases.informix

> > On Solaris the 4MB page size is used for any segment made resident, no > matter how many there are. Since page size is now settable in IDS 10, does the above have any implication on specifying a BUFFERPOOL page size? DG

↪ replying to David E. Grove

Michael Mueller — Mon, 04 Apr 2005 09:59:56 +0200 — source: Usenet: comp.databases.informix

I don't think so. I would choose a bigger BUFFERPOOL page size for tables with rows larger that 2k, on any platform and with any os page size. But this is of course a new area to Informix database folks. Michael David E. Grove wrote: >>On Solaris the 4MB page size is used for any segment made resident, no >>matter how many there are. > > > > Since page size is now settable in IDS 10, does the above have any > implication on specifying a BUFFERPOOL page size? > > > DG > > >

Glossary

IDS (Informix Dynamic Server)