Bold BI | Understanding DataSourceDataCacheIntervalInMinutes Setting
Published:
The DataSourceDataCacheIntervalInMinutes setting in the Bold BI config.xml file controls how long data source query results are stored in the application cache before fresh data is retrieved from the underlying data source. By default, this value is commonly set to 30 minutes, which helps improve dashboard performance while reducing the number of database or API calls.
Default Value
- By default, the setting is commonly configured as:
<DataSourceDataCacheIntervalInMinutes>30</DataSourceDataCacheIntervalInMinutes>
- This means cached query results are reused for 30 minutes before a new request is sent to the data source.
When to Use This Setting
- Adjust this value based on how frequently your source data changes and how often dashboards are accessed.
Configure a Lower Value (5–15 Minutes) - Use a lower interval when:
- Dashboard data changes frequently.
- Real-time or near real-time monitoring is required.
- Users expect to see the latest operational data.
Example:
<DataSourceDataCacheIntervalInMinutes>5</DataSourceDataCacheIntervalInMinutes>
Configure a Higher Value (30–60 Minutes or More)
- Use a higher interval when:
- Source data is updated periodically.
- The dashboard serves many concurrent users.
- Reducing database or API requests is important.
Example:
<DataSourceDataCacheIntervalInMinutes>60</DataSourceDataCacheIntervalInMinutes>
Steps to Configure the Cache Interval Setting
Step 1: Access the Configuration File
- Navigate to the UMS page and select Configuration under Settings
- In the Configuration page, locate the
bi/config.xmlfile:
Step 2: Modify the Cache Duration
- Update the value based on your business requirements.
- Example:
<DataSourceDataCacheIntervalInMinutes>60</DataSourceDataCacheIntervalInMinutes>
This configuration stores cached data for 60 minutes before fetching fresh data.
Step 3: Save the Configuration
Step 4: Validate Dashboard Behavior
- Open a dashboard and verify that data refreshes according to the configured cache interval.
How the Cache Works
- A dashboard requests data from a connected data source.
- Bold BI executes the query and stores the result in cache.
- Subsequent requests use the cached data until the configured interval expires.
- After expiry, the next request retrieves fresh data and rebuilds the cache.
Best Practices
- Start with the default value of 30 minutes.
- Use lower values only when frequent data updates are required.
- Monitor dashboard performance and database load after modifying the setting.
- Avoid extremely small intervals unless real-time visibility is a business requirement
Related Articles
EO
