How Symphony Caches Data

This applies to: Visual Data Discovery

Symphony uses a visual cache to enhance performance in scenarios where large numbers of users are concurrently viewing the same shared visuals. A metadata cache is also used to store field statistics. This cached data is shared between users only if they have the same data access permissions and security context.

Caching is enabled by default for all data sources. Symphony does not requery the data source for data unless you manually clear the cache, or define a refresh schedule. See Cache Tab and Trigger Refresh Jobs.

Available cache settings and options include:

  • Data Cache: Symphony caches query results and common cached data for multiple visuals that use this source. When you create a visual that uses this source, the first data request is sent to the Symphony cache. Symphony returns the cached data, if available.

    If the data is not available in the cache, Symphony next queries the data source. The results are returned and stored in the cache, and the visual displays the returned data.

  • Statistics Cache: When enabled, field metadata, such as minimum, maximum, and distinct values numbers are cached. This toggle also controls the availability of the Field Statistics Configuration option and scheduled refresh settings.

  • Field Statistics Configuration: When enabled, you can enable or disable caching and scheduling for individual fields, or manually refresh the cached data for individual fields. Fields that include a statistics override that prevents refreshing are indicated by an exclamation point in a triangle.

  • Schedule Refresh Settings: Enable and define Periodic or Advanced refreshing of fields with Schedule Refresh enabled. If you disable Schedule Refresh Settings, any schedule you had set up previously is deleted.

If a Custom Range has been defined for a field, the minimum and maximum fields used in filters remain unchanged when you refresh source data. These fields are shown with cache actions disabled on the Cache tab.

You can refresh the entire data source, all the fields in a data source, or select fields in a data source. For more information, see:

You can force Symphony to bypass the cache and to query the underlying data source by selecting Refresh All from a Symphony dashboard menu.