Disable Data Caching for a Data Source

This applies to: Visual Data Discovery

The Symphony data cache is a temporary storage area containing the aggregated data from your data sources. Two caches are supported: the visual (visual data) cache and the metadata (field statistics) cache. By default, caching is enabled for all data sources using both caches. However, you can disable all caching if your data source is constantly being updated, or you do not want to allocate the required RAM or if the performance of your data source is so high you do not need to store the aggregated queries.

To disable data caching:

1. Make sure you are logged in as a user with the Administer Sources privilege, or a user with read and write permission for the data source.

2. Select the Sources option from the main menu. The Data Sources page appears.

3. On the Sources page, locate and select the data source configuration you want to edit. The Source Creation work area opens.

4. Select the Cache tab. All the fields from your data source are listed.

   

5. Disable (toggle off) Data Cache. Data caching is disabled for the data source configuration. Data will be freshly loaded into the Symphony cache the next time it is requested from the data source.

6. Optionally, Disable (toggle off) Statistics Cache. Field metadata caching is disabled for the data source configuration.  Data will be freshly loaded into the Symphony cache the next time it is requested from the data source. Data will be freshly loaded into the Symphony cache the next time it is requested from the data source.

   If you have set up refresh jobs for this data source, a warning appears that the jobs are disabled and the schedule deleted for this data source. Select Ok to continue disabling Statistics Cache and delete the schedule.

7. Exit the source data configuration when you've finished making your changes.