Is there any performance reason to have the Temp Dbspaces anything
other than the default page size?

Informix 11.10 and 11.50
Linux Redhat 4 and 5

Our current system has standard dbspaces and bufferpools of 2, 4 and
8. Our Temp Dbspaces are 4K.
I am wondering why they were ever created at 4K rather than the
default page size of 2K and thinking of changing them back to 2K. Or
should they always be created as the largest page size possible?

Would it be better to create Temp Dbspaces as 16K and they could have
their own private bufferpool?

Thanks
Roy

On 24/06/2010 13:36, Roy Mercer wrote:
Well, yes.

Basically by having a separate PAGESIZE dedicated just for temporary dbspaces, you can isolate out all temp activity to a separate
bufferpool to all non-temp activity.

No point having a BUFFERPOOL for specific page sizes if no dbspaces are at that page size.