ICACHE()
From Recital Documentation Wiki
Revision as of 15:39, 27 October 2009 by Helengeorge (Talk | contribs)
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