All Manuals > LispWorks® User Guide and Reference Manual > 45 The SQL Package

cache-table-queries Function

Summary

Controls the caching of attribute type information.

Package

sql

Signature

cache-table-queries table &key database action

Arguments
table
A string naming a table, :default or t.
database
A database.
action
t, nil or :flush.
Description

The function cache-table-queries provides per-table control on the caching in a particular database connection of attribute type information using during update operations.

If table is a string, it is the name of the table for which caching is to be altered. If table is t, then action applies to all tables. If table is :default, then the default caching action is set for those tables which do not have an explicit setting.

database specifies the database connection, its default value is the value of *default-database*.

action specifies the caching action. The value t means cache the attribute type information. The value nil means do not cache the attribute type information. If table is :default, the setting applies to all tables which do not have an explicit setup.

The value :flush means remove any existing cache for table in database, but continue to cache.

cache-table-queries should be called with action :flush when the attribute specifications in table have changed.

See also

*cache-table-queries-default*
*default-database*


LispWorks® User Guide and Reference Manual - 01 Dec 2021 19:30:56