All Manuals > LispWorks User Guide and Reference Manual > 47 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 - 13 Feb 2015

NextPrevUpTopContentsIndex