Product Overview
Strengths
Product Features
Use Cases
Caching and Refreshes
When chart data is not updated frequently, caching can reduce database loads and accelerate data viewing. In some scenarios (including dashboard playback), chart auto-refresh is required to obtain the latest data.
Through caching and refreshes, you can achieve the above scenarios.
Note:
1. If both refreshes and caching are enabled, the refreshes will read the cached data. If real-time refreshes are required, disable caching.
2. Caching is determined by the executed SQL statements. Therefore, if row/column-level data permissions are applied, you may not experience the performance gains from caching during the initial data access. Once the cache is established, you will experience accelerated data access in subsequent accesses.
3. When caching is not enabled, pay attention to the refresh frequency settings. Since an excessively high refresh frequency may bring too many requests to a database, we strongly recommend that you do not use the auto-refresh feature for business databases. A secondary database can be provided for high-frequency data access.
Through this document, you will learn the following:
Setting Caching
Setting Auto-refresh
Setting Caching
Caching uses the server caching solution (caching in the Business Intelligence (BI) server) instead of client caching. Therefore, users with the same permissions can share the cached data.
1. Go to the editor, then select Cache and Refresh under the More icon of the component.
2. In the sidebar editing panel, enable caching.
3. To display the current data time on the chart, you can enable display cache information. For a concise display, you can disable this option. The effect of enabling cache information display is as follows:
4. The caching frequency supports the following modes:
Calculation Method | Setting Item Description | Description |
Duration | Set the cache validity period to the specified duration. The duration is calculated from the first time of caching. The minimum cache validity period is 5 minutes. | Start the calculation from cache creation. |
Each day | Set the cache validity period to a specific time of each day. | In scenarios requiring scheduled data updates, we recommend using this mode. For example, if the cache validity period expires at 8:00 each day, the old cache will be deleted at 8:00 each day. |
Each hour | Set the cache validity period to a specific time point of each hour. | For example, if the cache validity period expires at the 30th minute of each hour, the old cache will be deleted at the 30th minute of each hour. |
5. To forcibly clear the cache and obtain the latest data, you can click Clear Current Cache. Additionally, you can click Refresh Data on the dashboard to clear the cache of all charts on the current page.
Setting Auto-refresh
When you need to obtain the latest data but cannot operate the screen, you can enable auto-refresh to automatically trigger the data refresh service.
1. Go to the editor, then select Cache and Refresh under the More icon of the component.
2. In the sidebar editing panel, enable automatically refresh.
Auto-refresh supports a minimum refresh frequency of 5 seconds.
If both caching and refreshes are enabled, the refreshes will read the cached data. For example,
Set the caching time to 8:00 each day and the refresh frequency to 1 minute.
The user creates Cache A when accessing data for the first time at 7:50.
The chart automatically refreshes every minute, and the refresh at 7:59 still reads the data of Cache A.
When the chart refreshes at 8:00, Cache A expires, and Cache B is built. At this moment, the data of Cache B is displayed.
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback