Database/Memory page

Home

4D v19

4D Design Reference

Database Settings

Database/Memory page

You use the settings on this tab to configure the cache memory for the database.

Database Cache Settings

Calculation of adaptive cache: When this option is checked, management of the memory cache is done dynamically by the system — respecting limits that you set. This allows configuration of a high performance memory cache adapted to most configurations. The size of the memory cache is then calculated dynamically depending on set parameters. The values offered by default correspond to standard 4D usage.
- Memory to be reserved for other applications and for the system: Portion of the RAM memory to reserve for the System and other applications. This value is increased for optimization when other applications are running on the same machine as 4D.
- Percentage of available memory used for cache: Percentage of the remaining memory allocated to the cache by default.
  To obtain the size allocated by default to the cache, simply perform the following calculation: (Physical memory – Physical memory to be reserved) X Percentage of the memory used for the cache. In the adaptive mode, the size of the memory cache varies dynamically depending on the needs of the application and the system. You can set limits using the following two options:
- Minimum Size: Minimum amount of memory that must be reserved for the cache. This value cannot be less than 100 MB.
- Maximum Size: Maximum amount of memory that can be used by the cache. This value is virtually unlimited.
Setting limits is particularly useful for databases that are distributed on machines for which you do not know the memory configuration a priori. In this case, the limits set let you guarantee a minimum performance in all cases. The following diagram illustrates this behavior:
Example for calculating cache memory:
Physical memory to reserve = 256 MB
Percentage of the available memory used for the cache = 50%
Maximum size = 1 GB Minimum size = 128 MB

Calculation of adaptive cache not checked: this mode, you set the size of the memory cache for the database yourself. 4D then displays an entry area that allows setting the memory cache to use as well as information related to the physical memory (RAM available on the machine), the current cache and cache after restart (taking your changes into account).

The size of the memory cache that you enter will be reserved for the 4D database, regardless of the state of machine resources. This setting can be used in certain specific configurations, or when the database is designed to be used on dissimilar systems in terms of memory. In most cases, the adaptive cache offers better performance.

Flush Cache every … Seconds/Minutes: Specifies the time period between each automatic saving of the data cache, i.e., its writing to disk.
4D saves the data placed in the cache at regular intervals. You can specify any time interval between 1 second and 500 minutes. By default, 4D saves your data every 20 seconds. The application also saves your data to disk each time you change to another environment or exit the application. You can also call the FLUSH CACHE command to trigger the flush at any moment.
When you anticipate heavy data entry, consider setting a short time interval between saves. In case of a power failure, you will only lose the data entered since the previous save (if the database is running without a log file).
If there is a noticeable slowing down of the database each time the cache is flushed, you need to adjust the frequency. This slowness means that a huge amount of records is being saved. A shorter period between saves would therefore be more efficient since each save would involve fewer records and hence be faster.
By default, 4D displays a small window when the cache is flushed. If you do not want this visual reminder, you can uncheck the Flushing progress option on the Interface page.