SET CACHELOAD

Purpose

Map table into memory

Syntax

SET CACHELOAD ON | OFF | (<expL>)

See Also

SET DCACHE, SET ICACHE

Description

The SET CACHELOAD command can be used in association with the SET DCACHE command. It loads the table and index cache into memory when the table is used exclusively. Although this can be a lengthy process, further access to the table is accelerated dramatically. By default, CACHELOAD is OFF.

Example

set exclusive on
set dcache to 500
set dcache on
set cacheload on
use patrons index events
set dcache off