$MAX_CACHE_SIZE

Set the maximum size of occurrence that is retrieved in the select cache after subsetting.

Arguments

Size—cache size in bytes; valid values are:

• Numeric value from 1 through 32000.
• -1—maximum available
• 0—effectively disables correct management of foreign key caching.

Caution: If Uniface manages referential integrity, it is recommended that you set the value greater than zero .

Defaults

Assignment file:	application assignment files
Section:	[SETTINGS]
Default value:	Varies depending on Uniface versions and operating systems

Description

$MAX_CACHE_SIZE influences the caching behavior of Uniface. The maximum cache size refers to the size of the automatic field lists that are stored in cache. The complete occurrence will be placed in select cache when the field length (measured in bytes) is smaller than the Size specified by this setting. You would typically tune the maximum cache size by analyzing record key and foreign key lengths in relation to hitlist size.

If the occurrence length is larger than the size set, only the primary key or physical occurrence address is placed in select cache.

Setting $MAX_CACHE_SIZE to 0 can cause unpredictable behavior during referential integrity checks performed during occurrence deletes. A zero value might be useful only if you choose to have referential integrity handled by the database.

The default setting is approximately half a kilobyte, but varies between Uniface versions and operating systems. If a record is less than this size, Uniface uses the select cache mechanism. If larger, the primary key or physical record address hitlist mechanism is used.