Set different cache durations for different periods throughout the day/week

Feature Suggestions
1

Use case

We share dashboards through a sharable link with employees who do not have holistics accounts, and would like these dashboards to be refreshed on a reasonable basis - say every 60 minutes. However, there are certain times when we don’t need these dashboard to be refreshed at this frequency - e.g. during the night, or on weekends.

It would be great if we could configure more fine-grained cache durations. E.g.:

  • 60 minutes between 5:00 - 18:00 Monday - Friday, otherwise 24 hours.

The main goal of this would be to have refreshed data during business hours, while still minimising calls on the database.

Screenshot 2022-12-14 at 16.29.04
Screenshot 2022-12-14 at 16.29.041744×644 39.4 KB

2

Hi Daniela,

Let us confirm what we understand about your case: you are worried that every 60 minutes the cache refresh will call your database. If so, we believe you were misunderstanding our cache refresh mechanism :blush:

You can find the cache mechanism at Caching Mechanism (Cache) | Holistics Docs.

TL;DR: 60 minutes (your cache duration setting) is the amount of time we store your query result into cache for optimizing of calling database. You will call your database in two scenarios:

  1. The first time you open the dashboard with no cache
  2. After your cache duration is expired, someone use the dashboard → The cache will call again

The cache is designed to optimize calling your database. So I hope this could be helpful for you!