Qorus Integration Engine®  4.0.3_git
Qorus SQL Object Cache

Qorus implements a cache for SqlUtil-based AbstractTable objects for use with DML in Qorus interfacing code. This is because the acquisition cost of an AbstractTable object is relatively high, due to the necessity of reading the dataserver's data dictionary for the table and all associated properties (indexes, constraints, etc).

Objects in the cache are referenced according to their datasource; if a datasource is reset, then all associated objects in the cache are automatically purged.

Objects in the SQL object cache may need to be purged manually due to changes in the database; this can be done with the appropriate REST API call.

See also
SQL Object Cache API for more information