The buffer cache sizes you specify for the IQ store and temporary store will vary based on several factors. The default values (16MB for the main and 12MB for the temporary cache) are too low for most databases. The actual values required for your application depend on:
The total amount of physical memory on your system
How much of this memory Sybase IQ, the operating system, and other applications need to do their tasks
Whether you are doing loads, queries, or both
The schema configuration and query workload
Read the next several sections for guidelines in determining the best settings for your site.
The following diagram shows the relationship between the buffer caches and other memory consumption.
Figure 4-1: Buffer caches in relation to physical memory
The following sections describe each part in more detail and provide guidelines to help you determine how much memory each part requires.
