Speed Up Loading of TXDs Containing Large Numbers of Recodes

If you make extensive use of TXD files and recodes, then you may wish to make a change to the SuperCROSS configuration that will improve performance when loading a TXD file containing a large number of recodes.

By default, SuperCROSS uses a MAP statement in the TXD file to store details of each recode. This maps the source value code to the result value name. For example:

RECODE "Gender" FROM "Gender" FACTTABLE "Customers"
RESULT "Male"
RESULT "Female"
MAP CODE "M" VALUESET "C_Gender" TO "Male"
MAP CODE "F" VALUESET "C_Gender" TO "Female"
END RECODE

This format can take some time to parse, because of the need to find the index for both the source and result values.

To improve the performance of SuperCROSS and Production System, you can configure SuperCROSS to save recodes using FASTMAP statements instead. These statements save the recode as a mapping between the source value index and the result value index.

For example:

RECODE "Gender" FROM "Gender" FACTTABLE "Customers"
RESULT "Male"
RESULT "Female"
F 1 0
F 2 1
END RECODE

Configure SuperCROSS to use FASTMAP for Recodes

To configure SuperCROSS to use FASTMAP for recodes, you need to edit the super.ini configuration file. If you installed to the default location, this file is located in C:\ProgramData\STR\SuperCROSS.

Make sure you close SuperCROSS before making changes to the super.ini configuration file.

1. Open the file in a text editor.

   

   Make a backup copy of this file before making any changes.

2. Search the file to see if it contains a [Recode] section similar to the following:

   CODE

   [Recode]
   UseFastMap=0

   If there is no existing [Recode] section, then you will need to add the whole section to the end of the file.

3. Set UseFastMap to 1:

   CODE

   [Recode]
   UseFastMap=1

4. Save your changes.

Optional Step: Activate FASTMAP for Summation Option Recodes

The UseFastMap setting applies to recodes based on all types of field except the summation options. Using FASTMAP for summation options is not recommended.

However, should you wish to use FASTMAP for summation option recodes, you can configure this by adding UseFastMapForSummation=1 to super.ini:

[Recode]
UseFastMap=1
UseFastMapForSummation=1

This setting only applies when UseFastMap is set to 1.