Icon Frequently Asked Questions

When creating tables there are defaults for index page size, BLOB block size, and buffering sizes. Is there a way to determine what the best values would be for a particular table ?

The best values are the defaults:

INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

The only time you'll need to increase the index page size is if you have a very large index column or columns in a particular index, and that fact is making the index key size too large to fit on the existing index page size of 4k.

The BLOB block size should be increased if you're storing very large BLOBs in the table. For example, if you're storing 2-10 meg (or higher) BLOBs in your table, then you should increase the BLOB block size to at least 8k or higher

Only if you run into multi-user, file-sharing, performance issues should you increase the buffer sizes, and then only by 32k-64k at a time. Having too much buffer space can be just as bad as having too little. Increasing the buffer sizes usually does not do much good for single-user or client-server applications where the database tables are being accessed via a local drive.
Image