Cache Size

With the setting -c [size] you can configure how large an initial memory cache you want the database server to allocate. he more memory cache, the more memory the database engine will use. As a standard, if you do not use this setting, the database server will allocate 2 MB internal (primary) memory (RAM).

The best option is to reserve RAM memory corresponding to the entire size of the databases that the database server is running. For example, if the total size that the database runs is 3 GB, then you enter -c 3G (keep in mind that the total database size usually expands as more and more data is saved).

The higher the cache, the better the performance. However, make sure that you do not enter a larger cache size than the available RAM memory since this will have the opposite effect on the performance. Therefore it is wise to equip the computer with a large RAM memory. If you expect that your databases (added together) will take up several GB, then you should use a 64-bit Windows. When installing MONITOR on a 64-bit Windows then the 64-bit SQL Anywhere will be installed automatically.