Improve Remapping Speed

Using the Remap function in EQuIS Professional may be slow, especially with a large database or a large number of updates. The Remap function may work initially, then time out on subsequent attempts.

Improve Remap Function Speed

The following may help improve the Remap function speed when working with a database of 20,000+ records or a large number of rows. Remapping is time-intensive, which is especially evident with larger datasets, rows, higher numbers of remapped values, and when making numerous actual updates.

1.Ensure RT_REMAP and RT_REMAP_DETAIL remap settings are correct.

2.For tables, only open the table you want remapped, as the remap executes on all open tables.

3.Include the table name in the remap record instead of using the "*" wildcard, which applies to all open tables/reports, for example:
DT_RESULT.LAB_QUALIFIER instead of *.LAB_QUALIFIER

4.Only select the remaps you want executed.

5.Select individual remap records in the remap form instead of the parent remap set to only execute the single remaps.

6.The slow speed issue may be resolved with auto-remapping.

Additional Items to Consider

Consider the following items in regard to the speed of performing a manual remap:

•Network speed

•Amount of RAM on computer

•Age and architecture of processor (32 vs. 64-bit)

•Number of records/rows

•Size of RT_REMAP_DETAIL table