Example 36.17 Optimizing Cache Sizes with the TUNEFAME= and TUNECHLI= Options

The following statements show how to use the TUNEFAME= option, the TUNECHLI= option, and a RANGE= option for selecting pricing time series in the TRAINTEN database. The selected time series are written to the SAS output data set. The Fame database engine’s virtual memory is given in megabytes (MB), so this example sets the cache size to 100 MB. The Fame CHLI engine’s virtual memory is also given in megabytes (MB), so this example sets the CHLI cache size to 100 MB. These two settings correspond to the default settings. Both the Fame 4GL engine and the Fame CHLI engine can use a cache size ranging from 0.1 MB to 17,592,186,000,000 MB.

 
libname lib5 sasefame "%sysget(FAME_DATA)"
  wildcard="?UHIGH"
  tunefame=nodes 100
  tunechli=nodes 100
  convert=(frequency=business technique=constant) 
  range='23jul1997'd - '25jul1997'd 
  ;
 
data trout(drop=C:);
   set lib5.trainten;
run;
title1 'TRAINTEN DB, Pricing Timeseries, TUNEFAME=NODES and TUNECHLI=NODES Options';
proc print data=trout;
run;

proc contents data=trout;
run;

Output 36.17.1 and Output 36.17.2 show the results.

For more information about tuning the use of virtual memory, read about TUNE CACHE NODES in the section "TUNE CACHE Option" in the online document Fame 10 Online Help.