Trading Networks 10.7 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Caching Assets and Query Results | Query Results Cache Settings
 
Query Results Cache Settings
The TNQueryResults cache stores the results of a database query. Set the cache configuration values for the fields listed in the following table:
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)