Setting index expiration for inline view indexes
Use NOTES.INI settings to control when inactive view indexes expire and are flushed out of memory.
About this task
- inactive views in open databases
- cached views in closed databases
Procedure
Use the settings described in the following table that correspond to the type of inline view
index: design-enabled or static-enabled.
Tip: To determine whether an inline view index is static-enabled or design-enabled, use
the show dbs * inline views command or the dbcache show inline
views command. Look at the Type column in the output.
Setting | Description |
---|---|
INLINE_VIEW_INDEX_DESIGN_ACCESS_MIN=<minutes> | Open database view expiration for design-enabled inline indexes Default: no expiration. |
INLINE_VIEW_INDEX_STATIC_ACCESS_MIN=<minutes> | Open database view expiration for static-enabled inline indexes Default: no expiration. |
INLINE_VIEW_INDEX_DESIGN_CACHE_MIN=<minutes> | Closed database view expiration for design-enabled inline indexes Default: 5 minutes |
INLINE_VIEW_INDEX_STATIC_CACHE_MIN=<minutes> | Closed database view expiration for static enabled inline indexes Default: 5 minutes |