browse lookup - spped up selection
Dennis Malen
dmalen at malen.com
Thu Apr 13 14:56:11 PDT 2006
This probably was discussed before.
When a browse lookup is used the first part of the setup is to define how
you are looking the information in the target file. At that point there is
an option for the use of only one index selection.
The browse lookup utility then allows you to create processing in
conjunction with your lookup that has many different criteria. If the
processing does not match one can use a drop command etc.
The problem in that approach is that the lookup takes a very long period of
time as every record that meets that criteria is chosen in the index. As
every record gets a match there may be 5 other criteria that has to be
reviewed in the processing table to determine whether it should be shown on
the browse lookup screen or deleted (dropped).
Using a selection format is obviously a lot quicker.
Is there any way to speed up the process using a browse lookup.
Regards,
Dennis Malen
516.479.5912
More information about the Filepro-list
mailing list