3 Replies Latest reply on Jun 29, 2016 4:39 PM by Russell Christopher

    How often is "Refresh Less Often"

    Jack May

      I'm looking at the "Refresh Less Often" setting on Tableau Server 9.3. This setting is really broad and before I change it, I'd like some specifics. When does a report go get fresh data if this is set to Refresh less often? Should it be getting new data every time a new browser is opened, or is there some other cadence? Does it make a difference whether we have live or extract data sources? Does it matter whether they're file-type or server-type data sources?

       

      We mostly have data sources that are updated once a day, it doesn't seem like we'd need to refresh very often, and I don't want to take the performance hit, but we've recently seen our Tableau 9.3 Server showing a lot more reports with out-of date data.

       

      Thanks,

      -Jack May

      IDEXX Laboratories, Inc.

        • 2. Re: How often is "Refresh Less Often"
          Jack May

          Does that mean if no one opens the dashboard for 12 hours (eg, between 7:59 PM Wed and 8:01 AM Thurs) that at some point Tableau will recognize that the data is stale and refresh the cache?

           

          What if then

          - the dashboard is opened 7:00 AM

          - the data source is refreshed or republished at 8:15

          - and the dashboard is opened 8:30

           

          Does the user see old data or new?

          • 3. Re: How often is "Refresh Less Often"
            Russell Christopher

            At a high level: 

             

            Items in the cache expire regardless of whether they are viewed again during the 12 hour period or not. There is no "reset" on the cache expiration time if someone views something.

             

            Any time a data source is re-published or modified, cache is blown away. We consider a newly refreshed extract to be a new database as well - therefore cache is expired for a data source even when it's extract refreshes.

             

            Tableau Server never proactively refreshes the cache. You have to do something to cause "an answer" to get cached - that might be an interactive viz request, it might be a subscription executing, but something is happening to make Tableau do something - Tableau doesn't care about proactively refreshing the cache itself (which makes sense - why do tons of extra work when there's no real guarantee anyone would even USE the updated cache entries...)

             

            When something is added to the cache, a timestamp is also included in the metadata associated with the cache entry. If your viz executes 12+ hours later, it is likely vizqlserver may actually SEE the "old" cached object, however it will be ignored because it is stale. At that point, vizqlserver will execute a query, get "new" data, and that new data will be cached, essentially replacing the old stuff that wasn't good anyway.

            5 of 5 people found this helpful