Page size for DBSPACETEMP?

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: > 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 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.