Cache In Dashboard
When you create a dashboard and add a tile to it, the first query from that tile would go directly to your database. However, after every refresh, subsequent queries would come from the cache and would be faster.
So for the first time, the query goes directly to your database, and if it gets the results back, the system would cache (store) that data. So the next time you come back to it, it’s going to be significantly faster because the data would be coming from cache instead of your database.
For example, if you add a Line chart to visualize sales performance, the first query of your sales data would come directly from your database. However, when you refresh your dashboard, the data would come from the cache and you would get the result faster.
The cached data will remain and continue appearing during every refresh as long as everything remains the same. However, a new database query will occur and a new set of data will be generated from the dashboard if you make changes to the tile or if any of the elements change.
For example, if you have a date range selected for a tile. Let’s say you are tracking sales performance for the last 7 days, every time you refresh the tile, it will pull from the database; because the ‘last 7 days’ is a rolling date range, which changes every single day.
Similarly, if you make changes to a tile in the dashboard, a new database query will occur and a new set of data will be cached to reflect your changes.
When you click on refresh, it makes a call to the database or the cache. If there's already cached data for each tile on the dashboard, clicking refresh will just pull that data again. However, if there's no cache data for a tile, it will make a call to the database.
Note: Clicking the refresh icon would refresh all the tiles in the dashboard. Follow the steps below if you only want to refresh a specific tile.
Follow these steps to refresh a single tile:
1. Click on the Options icon on that tile.
2. Click on the Refresh option to refresh that specific tile.
This option allows you to display a fresh/updated set of data on a tile. When you click clear cache and refresh, the cached data is erased and a new query is made to the database. This new data is then cached in place of the one erased.
Note: Clicking the Clear Cache & Refresh icon would refresh all the tiles in the dashboard. Follow the steps below if you only want to refresh a specific tile.
Follow these steps to clear cache & refresh a single tile.
1. Click on the Options icon on that tile.
2. Click on the Clear Cache & Refresh option to refresh that specific tile.
Last modified 2yr ago