SQLNegativeCache

Name

SQLNegativeCache -- Enable negative caching for SQL lookups

Synopsis

SQLNegativeCache [ on off ]

Default

SQLNegativeCache off

Context

server config, <VirtualHost>, <Global>

Module

mod_sql

Compatibility

mod_sql v4.10 and later

Description

SQLNegativeCache specifies whether or not to cache negative responses from SQL lookups when using SQL for UID/GID lookups. Depending on your SQL tables, there can be a significant delay when a directory listing is performed as the UIDs not in the SQL database are repeatedly looked up in an attempt to present usernames instead of UIDs in directory listings. With SQLNegativeCache set to on, negative ("not found") responses from SQL queries will be cached and speed will improve on directory listings that contain many users not present in the SQL database.

See also

Examples