DataTranslator Flexible limit

This feature optimizes DataTranslator runtime performance through a bounded in-memory cache with intelligent eviction. This feature is disabled by default.

When records are fetched from the server, they are stored in the IEC DataTranslator table and also placed into an in‑memory cache that uses a Least Frequently Used (LFU) policy. The cache can hold up to 20,000 records, while the table can persist up to 100,000 records. At runtime, if a requested record is not found in the cache, the record is retrieved from the IEC database and added to the cache. When the cache is full, the least frequently accessed entry is evicted, ensuring that the most frequently accessed records are retained.

Per-key usage frequency is collected daily and viewable in the DataTranslator administration page, where you can download used and unused translation records as CSV files for cleanup analysis.

When disabled, the default behavior applies: all fetched records up to the configured maximum record limit are loaded into a fixed-size in-memory cache at startup or reload. The default value is 20,000. No eviction occurs and the entries remain in memory until the next scheduled reload. The cache is bounded by the maximum record limit, and records that are not loaded at startup are not retrieved on demand at runtime.