Sybase IQ initially sets the size of the main and temporary buffer caches to 16MB and 12MB respectively. Change the default size of the main and temporary buffer caches to accommodate your applications.
Method |
When to use it |
How long the setting is effective |
|---|---|---|
-iqmc and -iqtc server switches |
Recommended method. Sets cache sizes at startup. |
From the time the server is started until it is stopped The -iqmc and -iqtc server startup options only remain in effect while the server is running, so you need to include them every time you restart the server. |