In the normal mode of operation there is a standard buffer pool that data, structure, and collection I/O all share. When data bases get over a half million records you can improve throughput by assigning a separate buffer pool for collections. MODE CBUFF accomplishes that.
The first argument is collection buffer size and the number supplied must be one of the following: 4096
8192
16384
32768
only one of the above four numbers are valid for size. The bigger the better.
The second number is the number of buffers desired. As a guidline we can tell you that every time we have used this we always say:
MODE CBUFF 32768 20
This mode statement must be put into a CONFIG
file as buffer pools are configured at invocation time.