Resolution:
Cache is fully stored in the memory(RAM). Cache_sync table is used to temporarily store the records that got expired. Which means only “delete” and “update” operations will insert deleted objects/entries into this table. Operations like Insert, Lookup do not insert any entries into this table. After cache_resync_interval, the cache_sync engine will read these expired objects/entries and remove them from cache. When it is trying to update the cache in the memory, it is also clearing the old entries from the cache_sync table. The number of entries in the tables depends up on the rate at which the updates are happening and the resync_interval selected for the cache.

KEYWORDS SMARTMAPPER CACHE CACHE_SYNC