Difference between revisions of "SET CACHELOAD"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET CACHELOAD=
 
 
 
==Class==
 
Performance and Optimization
 
 
 
 
==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==
<pre>
+
<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</pre>
+
set dcache off</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
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