Difference between revisions of "ICACHE()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to return optimum ICACHE size for a given index expression
 
Function to return optimum ICACHE size for a given index expression
Line 32: Line 30:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Indexing]]
 
[[Category:Indexing]]
 
[[Category:Indexing Functions]]
 
[[Category:Indexing Functions]]

Latest revision as of 16:26, 2 December 2009

Purpose

Function to return optimum ICACHE size for a given index expression


Syntax

ICACHE(<exp>[, <expN>])


See Also

INDEX, REINDEX, SET DCACHE, SET ICACHE


Description

The ICACHE() function returns the optimum size of the index buffer cache for an index created on the specified expression. The <exp> can either be a numeric value representing the width of the index key, or the index expression. This function is used in conjunction with the SET ICACHE TO command. The command SET ICACHE TO OPTIMUM can be used instead of the ICACHE() function to automate defining index buffer caches.

If the optional <expN> is specified and is greater than zero (0), the required memory allocation is returned.


Example

use names index names
size = icache(indexkey(1))
set icache to size
reindex
use names
set icache to icache(name+left(address, 5))
index on name+left(address, 5) to names


Products

Recital Server, Recital