Query Results Cache Settings
The TNQueryResults cache stores the results of a database query. Set the cache configuration values for the specified fields as follows.
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: ![*](bullet.gif) 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. ![*](bullet.gif) 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) |