i was unable to find an information about a caching in the sql datasource. Let’s assume we have 2 Clients seeing the same Dashboard and both have a 30 sec refresh rate. Is there a way to query the DB only once every 30 seconds and cache the result for all other clients ? Otherwise that would generate a large workload for the DB.
Is that maybe the default behaivor ? Or is there maybe a plugin providing such a functionality ?
Thank You !