Cache Constant Values
Within FTM, all static or semi-static database data should be cached. Use the
following guidelines when working with static data:
- Never do database lookups for static data. Read it from the cache.
- Core FTM caches most static data. An API for caching is provided (see Static Data Cache).
- Implement similar static data caches. Extend the API if the core FTM cache API is not sufficient for the specific FTM implementation.
- Cache data is stored in the integration bus shared memory. Therefore, there is a copy of the cache per message flow shared by all thread instances of the flow.
- The cache is reloaded when the execution group is reloaded or the integration node is restarted.
- The cache is also reloaded if a change is detected, within the cache polling interval, in the database.