LispWorks User Guide and Reference Manual > 38 The SQL Package

NextPrevUpTopContentsIndex

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 the 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 - 22 Dec 2009

NextPrevUpTopContentsIndex