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

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.

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!