step size

Set the step size for the Uniface stepped hitlist mechanism.

USYS$ORA_PARAMS = step size Number

USYS$ORA_PARAMS = ss Number

Description

This option specifies the step size of the Uniface stepped hitlist mechanism. The number specified must be in the range from 0 through 32,767. If you specify 0, the stepped hitlist mechanism is disabled, causing Uniface to internally finish the hitlist each time, before returning control to the application.

The actual step size used is always either zero or a multiple of the actual array fetch size. When necessary, Uniface uses the smallest step size greater than or equal to the specified step size which is a multiple of the array size. To avoid confusion, specify a step size which is either zero or a multiple of the specified array size.

When the fixed array size option is set, and the recommended step size is a multiple of the array fetch size, the array fetch size option only affects the performance of the application, and not the behavior. The step size option, on the other hand, determines how many records are processed before control returns to the application. This affects, for example, the behavior of the $curhits variable.

Related Topics