fixed array size

Description

By default, Uniface and the Oracle connector make optimal use of the memory that is allocated for Oracle array fetching. The size of the allocated memory is calculated based on the size of the largest possible record. When smaller records are fetched, the array fetch size is automatically increased to reduce the client/server communication overhead as much as possible. The step size of the Uniface stepped hitlist must be a multiple of the array fetch size which has been computed in this way. The step size may, therefore, be very large. Because the array size depends on the size of the record, the step size may vary for different tables.

If you want to avoid having large and varying step sizes, you can set the fixed array size option. The fixed array size option forces Uniface to use exactly the array size specified with the array fetch size option (or its default value), instead of dynamically computing the maximum array size.