By default, Sybase IQ sets the size of the main and temporary buffer caches to 16MB and 12MB respectively. Most applications will require much higher values (limited by the total amount of physical memory). See the preceding sections to determine the right settings for your system.
Once you know what settings you need, use the options described in Table 4-1 to set buffer cache sizes.
Method |
When to use it |
How long the setting is effective |
For more information, see |
|---|---|---|---|
-iqmc and -iqtc server switches |
Recommended method. Sets cache sizes when the database and server are not running. Allows cache sizes >4GB. Especially useful for 64-bit platforms, or if cache size database options are set larger than your system can accommodate. |
From the time the server is started until it is stopped You must restart the server to change buffer cache sizes. The -iqmc and -iqtc server start-up options only remain in effect while the server is running, so you need to include them every time you restart the server. |
“Starting the database server” in Chapter 1, “Running the Database Server,” in the Utility Guide. |
