Oracle optimization
This parameter is useful only if the parameter ORAOPTMIZ is set to Yes and is only useful for the Oracle database.
In this case, an optimization strategy FIRST ROWS is used for the left lists; then this parameter can be used to specify a number of lines to be searched as fast as possible in order to improve even more the optimization of searching times.
Level of localization/Global variable
The parameter is defined at the level Folder.Belongs to Module SUP (Supervisor) and to Group PRF (Performances),in which the following parameters can also be found :
- AUZMEMO (Create all memos)
- CLOMAX (Max no.)
- MAXUPDTRS (Update transaction limit)
- MEMTXT (Size of text memory)
- NBTRABUFF (Number of lines in memory)
- NXTREC (Threshold for last read read)
- ORAOPTMIZ (Oracle optimization)
- ROLLBACK (Lock attempts before rollback)
- SELWARN (Limit for control memos)
- TIMLCK (Unlock time in seconds)
- TIMOUT (Time limit for response)
The global variable GORAOPTNB is associated to it.
Comments
The value specified for this parameter is similar to the values indicated by the parameters LFTBOX, NBRCHOOSE and NBDERLUS (which are defined more accurately by the user).
Even if it is equal to 0, the optimization is still substantial as long as the parameter ORAOPTMIZ is set to Yes; It is a very acute optimization.