This method instructs the DSI to initiate the next transaction without waiting for the previous transaction to commit. It assumes that your application is designed to avoid conflicting updates, or that dsi_partitioning_rule is used effectively to reduce or eliminate contention. Adaptive Server does not hold update locks unless transaction isolation level 3 has been set. The method assumes little contention between parallel transactions and results in the nearly parallel execution shown in Figure 4-5.
Figure 4-4: Thread timing with the no_wait serialization method
no_wait provides the better opportunity for increased performance, but also provides the greater risk of creating contentions.
