The simple way I approach this is to:
Create chunk(s)/dbspace(s) with a different page size from the others,
Assign a separate/dedicated/sufficiently sized bufferpool to that page size,
Put your subject tables in these dbspaces (and perhaps run a SELECT * FROM table at least once to force it to be read).
Approach their index space similarly where feasible.
Always had good results/good performance with this approach in 12.10 on Linux, 11.50 on HP-UX, etc. I prefer it for mostly/almost always read only tables.
Assumes you have not already used all the page sizes in the existing dbspaces, assumes you have sufficient RAM for the bufferpools (which, since you want to keep tables in memory, you probably do).
Hal Maner
M Systems International, Inc.
------Original Message------
Hello,
i´d like to know if there is away for Informix to mark some tables or columns to stay "in memory" at long as possible.
I know there is the IWA, but we want a to try a more simple solution.
Informix 12.10 - Workgroup Edition Linux 64bit
------------------------------
Marc Demhartner
------------------------------
#Informix