Setting Up Caching

CONTENTS

Home

bipp’s Cache improves the performance of your Sheets and Dashboards plus reduces the load on your datasource. bipp caches your primary datasource data within the application, and uses the cached results to optimize the performance of your dashboards and sheets. Cache is enabled at the organization level. It can be overriden at the project or sheet level.

Here is how bipp manages caching:

  • Cached queries are stored and encrypted within the platform instance.
  • Query results from sheets, dashboards and the data viewer are cached. Queries must have a row limit less than 10,000 for caching.
  • When a new query is executed, bipp checks the cache. All columns, filters, parameters and row limits must match for the cached data to be used, otherwise bipp runs the query on the datasource.
  • Cached results are used if the SQL query is similar to the previous query.
  • If you Disable caching, all cached query results are removed.
  • During the cache refresh, bipp runs queries to get the fresh results. A short delay can be noticed in data fetch time.
  • Do not enable caching in projects or sheets where the query returns the Current Time. Using caching with the current time returns stale data. Override caching at the project and sheet level.

Managing Caching

You must have at least the Tenant Admin role to access the cache settings. Caching is disabled by default.

Enable Global Caching

  1. Enable Development Mode.
  2. Click Settings in the Navigation pane.
  3. Click Cache.

Managing Cache

  1. Set the Cache Duration. Cache Duration sets the maximum age (hours) of the cached data, controlling the staleness of your data. If the cache duration is reached, bipp refreshes the cache from the datasource.

  2. Set the Cache Refresh Rate. *Cache Refresh Rate is the frequency (hours) your cached data is refreshed.

  3. Click Enable.

Disable Global Caching

  1. Enable Development Mode.
  2. Click Settings in the Navigation pane.
  3. Click Cache.
  4. Click Disable.

All cached query results are removed.

Update Global Caching

  1. Enable Development Mode.
  2. Click Settings in the Navigation pane.
  3. Click Cache.
  4. Change the Cache Duration and/or Cache Refresh Rate.
  5. Click Update.

Manually Flush Cache

When caching is enabled, you can manually flush the cache to force a refresh of your cached data.

  1. Enable Development Mode.
  2. Click Settings in the Navigation pane.
  3. Click Cache.
  4. Click Flush Cache.

Flushing Cache

Overriding Global Caching

You can disable caching for a project or for specific sheets. For example, if a sheet uses Current Time in the query, caching returns stale data, and should be disabled.

Overriding Caching for a Project

  1. Click Projects in the Navigation pane.
  2. Open your Project.
  3. Click Settings Gear Project Navigation.

Overriding Cache Project

  1. Set the Project Cache toggle to Enabled or Disabled. This example shows caching as Enabled for the project.

Overriding Cache Project

Overriding Caching for a Sheet

  1. Click Insights in the Navigation pane.
  2. Open your sheet.
  3. Open Setting Sheet Settings.

Overriding Cache Sheet

  1. Click to enable or disable Fetch data from cache.
  2. Click Update.

Overriding Cache Sheet