Good memory management avoids page swapping. To minimize use of operating system files, increase or reallocate physical memory.
Insufficient memory severely degrades performance. If this is the case, you need to find a way to make more memory available. The more memory you can allocate to SAP Sybase IQ, the better.
Because there is always a fixed limit to the amount of memory, the operating system may sometimes keep part of the data in memory and the rest on disk. Paging or swapping occurs when the operating system must go out to disk and retrieve any data before a memory request can be satisfied. Good memory management avoids or minimizes paging or swapping.
The most frequently used operating system files are swap files. When memory is exhausted, the operating system swaps pages of memory to disk to make room for new data. When the pages that were swapped are called again, other pages are swapped, and the required memory pages are brought back. This is very time-consuming for users with high disk usage rates. Try to organize memory to avoid swapping and, thus, to minimize use of operating system files.
To make the maximum use of your physical memory, SAP Sybase IQ uses buffer caches for all reads and writes to your databases.