Local Configuration Cache

GENESIS can cache a local copy of a configuration database to reduce the number of times a SQL Server database needs to be accessed and protect against failure of the database or the network.

The configuration cache can be enabled or disabled on individual components. Enabling the configuration cache is easy:

  1. In Workbench, do one of the following:

    • Go to Home > Configure Application(s) settings.

    • In the Project Explorer, right-click on your project > Configure Application(s) settings.

  2. Under Available Applications, find your component and check the box for Local Cache.

The configuration cache is very useful to redundant systems. The central configuration database for both redundant servers can be located on one of the servers, and the configuration cache will allow both servers to access the configuration even if the server hosting SQL Server has failed.

The cached copy is stored in a SQLite database located at C:\ProgramData\ICONICS\11\Data\Cache. This database provides the caching by cloning all the configuration from SQL Server to this local SQLite database.

When a configuration is updated on SQL Server, there is a sequence to automatically refresh the cache. This avoids synchronizations issues and improves the chance of a cache hit (chance of finding the data locally which avoids access to the SQL Server instances). Also, there is no expiration time for the cached configurations, this implies that all data will always be available.