Store and Cache

Store

Store Element in Cortex are interfaces for external data stores like RDBMS, MongoDB, Redis, and Elasticsearch using Table Node tables as a proxy.

  • Store Element enables creating, reading, updating, and deleting data in these external stores.

  • Depending on the store implementation, some may support primary keys for uniqueness and indexes for better searchability.

If Store Element is enabled in a Table Node, I/O latency with external stores can be higher than in-memory tables.

This can be mitigated by using a cache to keep frequently accessed data in-memory, speeding up data retrieval. Stores are particularly useful for accessing and manipulating data in common databases shared with other systems.-

Enabling the Cache at Step 5 can be enabled to speed up operations on tables outside Cortex.

Cache

Size

Cache Policy

Retention Period

Last updated