You can refresh a cache manually at any time by using the Refresh Cache statement (refer to "Refresh Cache (EXT)" in the DataDirect Connect Series for ODBC Reference). The Refresh Cache statement can also be used to perform a Clean (complete) refresh in addition to the standard optimized refresh. A Clean refresh discards all of the data from the cache and repopulates it with data from the remote data source.Automatically refreshing a dirty cache is not always desirable. For example, if an application alternates fetches and inserts on a table, and the insert does not depend on any remote data source generated values, then the refresh between fetches is unnecessary. The RefreshDirtyCache (RDC) connection option (see Connection Option Descriptions) controls whether the driver automatically refreshes a cache with a dirty state. The state of a cache can be viewed by selecting the STATUS column of the SYSTEM_CACHES catalog table. See SYSTEM_CACHES Catalog Table for more information.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |