Example 40.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 40.17.1 and Output 40.17.2 show the results.

Output 40.17.1 Listing of TRAINING DB, Pricing Timeseries, TUNEFAME=NODES, and TUNECHLI=NODES Options
TRAINTEN DB, Pricing Timeseries, TUNEFAME=NODES and TUNECHLI=NODES Options

Obs DATE DJ30IN.UHIGH DJ__30.UHIGH F.UHIGH F___I.UHIGH GM.UHIGH GM__PP.UHIGH HPQ.UHIGH HWP.UHIGH IBM.UHIGH INDUT.UHIGH INTC.UHIGH JAVA.UHIGH JAVAD.UHIGH KO.UHIGH PEP.UHIGH SPAL.UHIGH SPALN.UHIGH SPALNS.UHIGH SPX.UHIGH SP_CI.UHIGH SP__50.UHIGH SP___C.UHIGH SUNW.UHIGH XOM.UHIGH XON.UHIGH
1 23JUL1997 8199.15 8199.15 41.0625 41.0625 59.1250 59.1250 67.3125 67.3125 107.000 8199.15 90.750 46.9375 46.9375 70.7500 38.4375 941.800 941.800 941.800 941.800 941.800 941.800 941.800 46.9375 63.125 63.125
2 24JUL1997 8174.53 8174.53 42.0000 42.0000 59.2500 59.2500 65.8750 65.8750 108.438 8174.53 90.625 46.8750 46.8750 70.4375 38.0625 941.510 941.510 941.510 941.510 941.510 941.510 941.510 46.8750 62.000 62.000
3 25JUL1997 8200.31 8200.31 41.5000 41.5000 57.8125 57.8125 66.1250 66.1250 108.438 8200.31 91.125 47.3750 47.3750 70.9375 38.7500 945.650 945.650 945.650 945.650 945.650 945.650 945.650 47.3750 63.000 63.000

Output 40.17.2 Listing of Contents of TROUT for TUNEFAME=NODES and TUNECHLI=NODES Options
Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
1 DATE Num 8 DATE9. 9. Date of Observation
2 DJ30IN.UHIGH Num 8      
3 DJ__30.UHIGH Num 8      
4 F.UHIGH Num 8      
5 F___I.UHIGH Num 8      
6 GM.UHIGH Num 8      
7 GM__PP.UHIGH Num 8      
8 HPQ.UHIGH Num 8      
9 HWP.UHIGH Num 8      
10 IBM.UHIGH Num 8      
11 INDUT.UHIGH Num 8      
12 INTC.UHIGH Num 8      
13 JAVA.UHIGH Num 8      
14 JAVAD.UHIGH Num 8      
15 KO.UHIGH Num 8      
16 PEP.UHIGH Num 8      
17 SPAL.UHIGH Num 8      
18 SPALN.UHIGH Num 8      
19 SPALNS.UHIGH Num 8      
20 SPX.UHIGH Num 8      
21 SP_CI.UHIGH Num 8      
22 SP__50.UHIGH Num 8      
23 SP___C.UHIGH Num 8      
24 SUNW.UHIGH Num 8      
25 XOM.UHIGH Num 8      
26 XON.UHIGH Num 8      

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.