Memory Cache Size | Vantage BYOM - 3.0 - Memory Cache Size - Teradata Vantage

Teradata Vantageā„¢ - Bring Your Own Model User Guide

Teradata Vantage
Release Number
May 2022
Last Update
Content Type
User Guide
Publication ID
English (United States)

Vantage BYOM caches models to eliminate the need to load a model for every query that uses the model, which improves performance. When the cache needs room for a new model, it removes the least recently used model or models. If all cached models are being used, the new model is loaded into the memory (if there is room in JVM memory) but not cached.

The following parameter configures the cache:
Parameter Description Default Value
CacheMaxLimit Specifies maximum size of cache. Recommendation is not to exceed 60% of JVM memory. 1.2 GB

When the parameter CacheMaxLimit has its default values, the cache can hold a model of at most 1.2 GB. This model size corresponds to a model file size (BLOB size in a database table) between 436 MB and 1.2 GB, depending on the model type. Different model types have different expansion factors in JVM memory. The largest expansion factor is 2.75 (corresponding to 1200/2.75 = 436 MB).

If the cache is too small for the model or models you want to cache, you can enlarge the cache by increasing the value of CacheMaxLimit. Enlarging the cache may require increasing the size of JVM memory to fit the cache (see JVM Memory Size and JVMMemStats Function). Teradata recommends that the cache uses at most 60% of JVM memory.

To change the cache configuration parameter, use the CufConfig JVMOptions field.

The following example increases the cache size limit to 3 GB and decreases the number of concurrent cache writes to 2.

JVMOptions: -DcacheMaxLimit=3g -DcacheWriteConcurrency=2