Query Results Cache Settings

Field

Description

Recommended Value

Maximum Elements in Memory

Total number of entries that this cache can keep in on-heap memory.

500

Eternal

Specifies how long entries are to remain in the cache.

Note:

When selected, entries in cache do not undergo time based eviction, and Time to Live and Time to Idle values are ignored. When Eternal is not selected, the entries remain in cache depending on the values of Time to Live and Time to Idle.

Not Selected

Time to Live

Maximum amount of time (in seconds) that an element can remain in the cache regardless of whether it is accessed or not.

Note:

A value of 0 indicates that elements in this cache do not have a time-to-live expiration. The default value is 0.

1200

Time to Idle

Maximum amount of time (in seconds) that an element can remain in the cache without being accessed.

Note:

A value of 0 indicates that elements in this cache do not have a time-to-idle expiration. The default value is 0.

300

Overflow to Disk

Specifies where entries are written when the memory-based portion of on-heap and off-heap cache is filled. When selected, the entries are written to disk when the cache is full.

Note:

This check box is not selected by default. Note that selecting this option can affect performance of Trading Networks especially where database entries for a particular transaction are distributed across cache and disk. Therefore, Software AG recommends disabling this option for use with Trading Networks.

The following behavior is noticed when cache is full and when the Overflow to Disk property is not selected:

For a bounded cache (when Maximum Elements in Memory is limited), the entries are evicted from the cache according to the eviction policy. These entries are later fetched from the Trading Networks database when required.

For an unbounded cache (when Maximum Elements in Memory is 0), an OutOfMemoryException is thrown. Increasing the Java heap size can accommodate more entries in cache.

Not selected

Memory Store Eviction Policy

Policy used to remove entries from the cache when the value in Maximum Elements in Memory is reached.

LRU (Least Recently Used)