|
|
|
Slow transaction commit performance was seen on Windows, with c-treeACE V11.0 - V11.2 Servers when there was one committer and another connection had an active transaction.
It was found that the effectiveness of COMMIT_DELAY could be improved when it calculated a sleep time that was not zero but was less than one millisecond, which equates to a zero sleep time on Windows. To improve the effectiveness of COMMIT_DELAY in that situation, a minimum delay of one millisecond was used on Windows.
Prior to this change, the COMMIT_DELAY sleep time calculation occurred even when only one connection was committing a transaction if at least one other active transaction existed.
With this change, COMMIT_DELAY_MINIMUM now only affects the COMMIT_DELAY sleep time if more than one connection is committing at the time that the COMMIT_DELAY sleep time is calculated.
