slctenhance

Specify that Uniface should not remove the cached SELECT statement until the next SELECT statement is different than the previous one.

USYS$MSS_PARAMS = slctenhance: on | off

Use

Available only for the MSS U3.0 (and above) connector

Description

The default setting of this option is off, which is the default Uniface behavior.

If set to on, Uniface does not remove the SELECT statement cache until the next SELECT statement is different than the previous one. If you have a one-to-many relationship situation where the number of records in the outer and inner entities is very large, and you have ProcScript similar to the following block, the default behavior of the SELECT cache mechanism can degrade performance.

retrieve
SetOcc "One-Entity", 1
while ($status > 0)
  SetOcc "Many-Entity", 1
  while ($status > 0)
    discard "Many-Entity"
  endwhile
  discard "One-Entity"
endwhile

Note: You should use this option only when you have ProcScript similar to the one described above.