Difference between revisions of "SET CACHELOAD"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Map table into memory | Map table into memory | ||
− | |||
==Syntax== | ==Syntax== | ||
SET CACHELOAD ON | OFF | (<expL>) | SET CACHELOAD ON | OFF | (<expL>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[SET DCACHE]], [[SET ICACHE]] | + | [[SET DCACHE]], [[SET ICACHE]] |
− | + | ||
==Description== | ==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 | + | 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== | ==Example== | ||
Line 24: | Line 20: | ||
set dcache off</code> | set dcache off</code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|CACHELOAD]] | [[Category:Set_Commands|CACHELOAD]] | ||
[[Category:Performance and Optimization]] | [[Category:Performance and Optimization]] | ||
− |
Latest revision as of 08:35, 4 February 2013
Contents
Purpose
Map table into memory
Syntax
SET CACHELOAD ON | OFF | (<expL>)
See Also
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