SQLNegativeCache [ on off ]
Default
SQLNegativeCache off
Context
server config, <VirtualHost>, <Global>
Module
mod_sql
Compatibility
mod_sql v4.10 and later
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.