Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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 done 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 set to `50` if caching is enabled, and is controlled by the local variable cache_size in the `SW_GET_SEQUENCE` stored procedure).

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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine