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