DYN_QUERY_CACHE

DYN_QUERY_CACHE_LIMIT

Platforms

All 16.5 (and later), with HPO

Abstract

Maximum dynamic query size to cache, in kilobytes.

Example

z/VM:

DYN_QUERY_CACHE_LIMIT = 10

Unix:

DYN_QUERY_CACHE_LIMIT=10

export DYN_QUERY_CACHE_LIMIT

Windows:

DYN_QUERY_CACHE_LIMIT=10

Details

Beginning with LISTSERV 16.5, dynamic query performance under HPO has been improved by caching queries run for authentication purposes. The intent is to speed up response time for queries run from WA against lists which use DQL queries for the purpose of defining owners, moderators, etc. LISTSERV will now cache the information after the first run against the directory server and use the cache for subsequent queries (e.g., "LISTS MODERATED BY" and "LISTS OWNED BY") for the same list. The cache is also available for any DQL back-end, including exits.

The cache is enabled by setting the DYN_QUERY_CACHE_LIMIT keyword to a non-zero value, where the value is in kilobytes, representing the maximum dynamic query size that will be cached.

Note: The dynamic query cache is disabled by default and must be enabled to take advantage of the performance improvement it offers.

Default Value

0 (cache is disabled)