Copyright © Cloud Software Group, Inc. All Rights Reserved

SW_ENABLECACHING

The SW_ENABLECACHING procedure enables the caching of work item (reqid) and case number (casenum) sequence numbers for the current database session.

Syntax

SW_ENABLECACHING ()

Notes

Caching reqid and casenum sequence numbers can be used to enhance batch SQL performance in appropriate situations.

When sequence number caching is enabled, the first transaction in the session retrieves its sequence numbers from the database, but subsequent transactions in the same session retrieve their sequences from the cache. (The size of the cache is determined by the value of the CNUM_SEQ_CACHE and REQID_SEQ_CACHE process attributes).

Unused sequence numbers in the cache are discarded when the database session terminates. This can result in gaps in the value of the sequence numbers if caching is used inappropriately. For example, if you enable caching for a session that simply starts a single case, all the unused iProcess case numbers will be lost.

Sequence number caching is enabled by default when a database session is started. Use the SW_DISABLECACHING procedure to disable sequence number caching.

For more information about sequence number caching, see "Sequence Number Caching" in TIBCO iProcess Engine Administrator's Guide.

The SW_ENABLECACHING procedure is part of the SSOLITE_MSG package.

Copyright © Cloud Software Group, Inc. All Rights Reserved