This section explains on how to configure the Data cache settings to improve dashboard performance by caching widget data during the interactions in a dashboard in the Bold BI.
The Data Cache allows you to improve the dashboard performance by caching the result of each widget and keeping the cached data in a dashboard for a particular amount of time.
NOTE: This feature is available in Bold BI Embedded Analytics but not in Cloud Analytics Server.
The mode should be either in-memory
or redis
. The widget data will be cached based on the selected mode.
Go to the Data Process
settings on the server page and select the Data Cache Configuration
tab.
The Data cache can be achieved through two modes:
In-Memory
The In-Memory
is the default cache memory for dashboards. It stores the data in the internal cache storage. You should configure the CacheMode
property for the in-memory
mode selection.
Redis
The Data is cached in an external server named Redis
. Redis is an open-source (BSD licensed), in-memory data structure store used as a database, cache, message broker, and streaming engine. Learn more about Redis
and its installation here.
In Redis
mode, find the connection string and test connection options. It will help to check whether it is a valid connection string or not.
The data refreshed time is provided on the dashboard view page. Disable the data refreshed time by clicking the checkbox.
By clicking the clear cache option, all dashboard cached memory should be cleared when the data cache is in an ON state.
NOTE:
Clear cache
option is visible only when the cache is present.
Please find more details about Data cache.