Difference between revisions of "SET CACHELOAD"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Map table into memory | Map table into memory | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | SET DCACHE, SET ICACHE, SET PCACHE | + | [[SET DCACHE]], [[SET ICACHE]], [[SET PCACHE]] |
| Line 23: | Line 16: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set exclusive on | set exclusive on | ||
set dcache to 500 | set dcache to 500 | ||
| Line 29: | Line 22: | ||
set cacheload on | set cacheload on | ||
use patrons index events | use patrons index events | ||
| − | set dcache off</ | + | set dcache off</code> |
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category:Set_Commands]] | + | [[Category:Set_Commands|CACHELOAD]] |
| + | [[Category:Performance and Optimization]] | ||
| + | [[Category:Performance and Optimization Set Commands]] | ||
Latest revision as of 16:47, 12 November 2009
Purpose
Map table into memory
Syntax
SET CACHELOAD ON | OFF | (<expL>)
See Also
SET DCACHE, SET ICACHE, SET PCACHE
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. OpenVMS users please note that to obtain the full benefit of SET CACHELOAD, your working set should be set to a suitably large value. 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
Products
Recital Server, Recital
