Cache In Dashboard
Last updated
Was this helpful?
Last updated
Was this helpful?
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 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 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 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.
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.
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.
