Change Notice: Default Cache Length (Looker 4.2+)


(Brett Sauve) #1

Looker caches (a fancy way of saying “stores” or “remembers”) the results of queries to improve performance. If one person requests some information, then another person requests identical information shortly thereafter, Looker returns the cached version so that the query does not have to run against your database again. This improves speed and reduces database strain.

Old Behavior

Previous to Looker 4.2, the default cache length was 5 minutes.

In other words, the default value for persist_for was 5 minutes.

New Behavior

As of Looker 4.2, the default cache length is 1 hour.

In other words, the default value for persist_for is 1 hour.

Reverting to Old Behavior

If you want to go back to a 5 minute cache there are two ways to do so:

  • Customers who joined Looker before release 4.2 can check the “Default query result persistence is 5 minutes” legacy feature to go back to a 5 minute cache.
  • All customers can set any cache length they like, including 5 minutes, by using the persist_for parameter at either the model level or explore level.

Query Caching Behavior in Looker
Looker 4.2 Release Notes
Legacy Features End-of-life Schedule
Looker 5.4 Release Notes
Looker 5.8 Extended Support Release Notes