If you're running LISTSERV HPO, you should upgrade to LISTSERV 16.5, which supports caching of dynamic queries: http://www.lsoft.com/manuals/16.5/LISTSERV16.5_WhatsNew.pdf



"Dynamic query performance under HPO has been improved by optionally caching queries run for authentication purposes (queries run for mail delivery purposes bypass the cache).  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 data source and use the cache for subsequent queries (e.g., "LISTS MODERATED BY" and "LISTS OWNED BY") for the same list. The cache is available for any DQL data source, including exits.



This improvement includes two new site configuration variables for tuning the DQL cache:



DYN_QUERY_CACHE_LIMIT: Sets the maximum query size that will be cached, in kilobytes. Default value of 0 disables the cache.

DYN_QUERY_CACHE_TTL: Sets the Time To Live (TTL), in seconds, of cache entries. Defaults to 15 minutes.



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



-- 

Liam Kelly

Senior Consulting Analyst

L-Soft international

[log in to unmask]



############################



To unsubscribe from the LSTSRV-L list:

write to: mailto:[log in to unmask]

or click the following link:

http://peach.ease.lsoft.com/scripts/wa-PEACH.exe?SUBED1=LSTSRV-L&A=1