SQL Object Cache API

Table of Contents

• Introduction to Development with the SQL Object Cache
• SQL Object Cache Function List

Introduction to Development with the SQL Object Cache

Using the SqlUtil module for DML is recommended for the following reasons:

• the SQL generated is database-independent
• database-specific optimizations can be automatically employed by SqlUtil without requiring programming expertise for the specific database being used
• dynamic SQL can be eliminated and therefore the database server's SQL statement cache can be used more efficiently (if applicable)
• SQL injection attacks can be prevented

To perform DML using the SqlUtil module, an AbstractTable object must be acquired; Qorus implements an SQL object cache for AbstractTable objects for DML to allow for efficient sharing of these objects, since the creation of an AbstractTable object is expensive in terms of CPU time and I/O bandwidth (many server round-trips are performed to query the server's data dictionary about the table's structure and associated attributes such as indexes, constraints, etc).

See also

sql-cache for more information

SQL Object Cache Function List

• OMQ::UserApi::UserApi::getSqlTable(): acquire an AbstractTable object for DML
• OMQ::UserApi::UserApi::getSqlCacheInfo(): get information about the cache
• OMQ::UserApi::UserApi::clearSqlTableCache(): purge AbstractTable objects from the SQL object cache