Increase the Commit Buffer Cache Size
Performance impact: Large
TimesTen resource cleanup occurs during the reclaim phase of a
transaction commit. During reclaim, TimesTen reexamines all the transaction log records
starting from the beginning of the transaction to determine the reclaim operations that
must be performed.
The reclaim phase of a large transaction commit results in a large amount of processing and is very resource intensive. You can improve performance, however, by increasing the maximum size of the commit buffer, which is the cache of transaction log records used during reclaim operations.
You can use the TimesTen CommitBufferSizeMax connection attribute to specify the maximum size of the commit buffer, in megabytes. This setting has the scope of your current session.