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.