Disable Data Caching for a Data Source
The Composer 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:
Make sure you are logged in as a Composer administrator.
In the My Data Sources table on the Data Sources page, locate and select the row displaying the data source configuration for which you want result set caching stopped.
The data source configuration wizard starts.
Select the Tables or Indices tab. See Tables/Indices Tab.
Turn the Caching switch OFF (to the left) at the bottom of the tab.
Select to save the data source configuration and close the wizard.
Data caching in both caches is disabled for the data source configuration. Data will be freshly loaded into the Composer cache the next time it is requested from the data source.