ICACHE()

From Recital Documentation Wiki
Revision as of 13:32, 23 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Class

Indexing


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 Database Server, Recital Mirage Server, Recital Terminal Developer