fcSDK Cache files: sometimes more trouble then they're worth
July 30, 2007
One of the features of the fcSDK is its ability to cache frequently-used, rarely-changed data, such as the schema meta-data (ADP tables), lists (Application Lists, Status codes, User-defined lists), geography data (states, countries, time_zones, currencies), configuration items, and strings. When the fcSDK starts up, it reads all of this data from the database and saves it into memory. In addition, it writes out the data to cache files. The next time the fcSDK starts up, if there are cache files present, it loads the data from the cache files, as opposed to having to go to the database. This improves the performance of the loading of the cache data, as reading from a local file is quicker than loading from a remote database. However, these cache files can often cause trouble. If a piece of cache data is changed in…