fcSDK Documentation Send comments on this topic.

Using the Caching Features of the fcSDK

Using the Caching Features of the fcSDK

During FCFL.NET initialization, frequently used and seldom updated data is pulled into memory as cache objects. The cached data is exposed as read only strongly typed objects.

fcSDK-based applications utilize cached objects to avoid extra round trips to the database which results in a dramatic application performance boost. They also make it easier to write fcSDK-based applications as commonly used data is readily available through strongly typed objects.

Cache Lifecycle

The cached objects are loaded during ClarifyApplication initialization. If enabled, cache objects will be persisted to the file system (cache files) as it is much faster to load the cache objects directly from the file system rather than the database.

During initialization:

Creation of cache files can be disabled using a configuration setting. The location of the cache files is also configurable.

Refreshing the Cache

Cache information can get out of date. Currently the only built-in cache object that will automatically detect if it is out-of-date is the Schema Cache. If you update non-schema data that you know to be cached you have two options.

Refreshing Caches

[C#] 

//update the Schema Cache
 CacheManager.UpdateCaches( CacheType.Schema );

//update all caches except the Schema Cache
 CacheManager.UpdateCaches( CacheType.Data );

//update all Caches
 CacheManager.UpdateCaches( CacheType.All );

[Visual Basic] 

'updates the Schema Cache
CacheManager.UpdateCaches( CacheType.Schema )

'updates the all caches except the Schema Cache
CacheManager.UpdateCaches( CacheType.Data )

'update all Caches
 CacheManager.UpdateCaches( CacheType.All );

Built-In fcSDK caches

The fcSDK comes with four built-in caches available through properties on ClarifyApplication. Each cache has some common characteristics:

Schema Cache

The SchemaCache allows you to programmatically browse the Clarify Schema at runtime. You can find out what Fields are in a View or what Relationships are present for a Table.

Schema Cache Usage Example

[C#] 

//get a reference to the case table
 SchemaTable caseTable = ClarifyApplication.Instance.SchemaCache.Tables["case"];

//print out some details about each case relation
 foreach(SchemaRelation relation in caseTable.Relationships)
{
    Console.WriteLine("Case Relation : {0}, Target Table {1}, Cardinality {2}",
        relation.Name, relation.TargetName, relation.Cardinality);
}

//print out some details about each case field
 foreach(SchemaTableField field in caseTable.Fields)
{
    Console.WriteLine("Case Field : {0}, Field Default {1}",
        field.Name, field.FieldDefault);
}

[Visual Basic] 

'get a reference to the case table
Dim caseTable As SchemaTable = ClarifyApplication.Instance.SchemaCache.Tables("case")

'print out some details about each case relation
For Each relation As SchemaRelation In caseTable.Relationships
    Console.WriteLine("Case Relation : {0}, Target Table {1}, Cardinality {2}", _
        relation.Name, relation.TargetName, relation.Cardinality)
Next

'print out some details about each case field
For Each field As SchemaTableField In caseTable.Fields
    Console.WriteLine("Case Field : {0}, Field Default {1}", _
        field.Name, field.FieldDefault)
Next

List Cache

The ListCache provides access to user defined (HierarchicalStrings) and global (GlobalStrings) lists.

Locale Cache

The LocaleCache provides access to Country, State and TimeZone information.

For more information on how TimeZones are used in fcSDK see also Time Zone Handling.

String Cache

The StringCache allows access to all the localizable application strings present in the string_db or fc_string tables.

This cache is slightly different in that it does not expose a collection and its accessor methods start with “Find”.

Custom Caches

Data that is often accessed and seldom updated can benefit from caching. fcSDK's built-in caches attempt to cover basic Clarify and First Choice database objects that meet this criteria. However, custom Clarify implementations may data that could also benefit from caching. By editing the application configuration file one or more Custom Cache Providers can be added and automatically put into memory during initialization.

While caching of often used, read-only data can greatly boost application performance please be aware that there are downsides to caching:

See Also

Basic Configuration  |  Time Zone Handling  |  Configuring Custom Data Providers