Improve the performance of TIBCO Scribe® Online Maps that use Lookup Blocks by enabling the caching option labeled,
Cache the results of this operation. When enabled, Lookup results are cached by the Agent until the end of the Map allowing the data to be reused without having to retrieve it again.
Data is cached as it is looked up instead of caching all of the data in the entity being searched. For example, if you are running a query that has to do with currency, when the Map needs to know the value of a specific currency, such as US Dollars, the lookup operation requests the value of that single currency and caches it. When the Map needs to know the value of Euros, the Lookup operation requests the value and caches it along with the value of US Dollars. The cache grows as each new piece of information is added. When a request is repeated, such as asking for US Dollars a second time, the cached data is used.
If data changes during the time the Map is run, the cached data is used and the changes are not taken into account. If you know that the values of the data retrieved by the Lookup Block may change during the execution of the Map, you may not want to enable caching. The default setting for this option is disabled.
NOTE: If the Lookup results are very large, they may not be cached. The maximum size of the cache is 10 MB.
For additional information on Lookup Blocks, see the following in the TIBCO Scribe® Online Help:
Lookup Block,
Lookup Block Example