![]() |
Copyright © TIBCO Software Inc. All rights reserved. |
The SW_ENABLECACHING procedure enables the caching of work item (reqid) and case number (casenum) sequence numbers for the current database session.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 set to 50 in the SW_ENABLECACHING procedure).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.
![]() |
Copyright © TIBCO Software Inc. All rights reserved. |