Advantage Database Server
Default = Half of the available system memory (RAM) at startup
This configuration entry specifies the maximum amount of memory (RAM) in megabytes (MB) the Advantage Database Server will use to cache index files, table headers, memo headers, and temporary files. If this setting is not found, the Advantage Database Server will determine an appropriate maximum value by dividing the currently available amount of free memory by two. In 32-bit operating system, Advantage will use no more than 256MB for cache unless the MAX_CACHE_MEMORY specifies a higher value. The amount of free memory is polled once per minute, and if the Advantage Database Server is using more than half of 80% of free memory, it will release enough memory so there will be at least 100MB memory available in the system. If the configured amount is zero, the Advantage Database Server will not cache any file data.
To set a specific amount of memory for the Advantage Database Server to use for caching, perform one of the following where "x" is replaced by the actual integer memory amount in megabytes (MB). To disable the cache system, specify a value of zero.
Add or modify the following line in the Advantage Database Server configuration file (ADS.CFG):
Add or modify the following DWORD value using the Registry Editor (REGEDIT.EXE):
Add or modify the following line in the Advantage Database Server configuration file (adsd.conf):
Add or modify the following line in the Advantage Local Server configuration file (adlocal.cfg):