Allocating memory appropriately is a key factor in performance for all IQ databases. Sybase IQ uses memory in its buffer caches for loads and queries. It also uses some memory for managing connections, transactions, buffers, and database objects.
Sybase IQ has two buffer caches, one for the main IQ Store and one for the Temporary Store. A local store on a query server shares the main buffer cache.The default sizes of these caches are not sufficient for a production data warehouse. You must adjust them to reflect the size of your database and tables, your mix of loads and queries, and other factors such as your operating system and other applications that can affect the amount of memory available.
For complete discussion of Sybase IQ memory use, server and database options that determine your IQ cache sizes, and other options that affect the total available memory on some platforms, see “Managing System Resources,” in Sybase IQ Performance and Tuning Guide.
