browse lookup - spped up selection

[Dennis Malen]

Thanks Nancy,

That's what I am experimenting with right now.

Unforetunately using Ken's suggestion does not read the selection set.

Dennis
----- Original Message ----- 
From: "Nancy Palmquist" <nlp at vss3.com>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Friday, April 14, 2006 3:29 PM
Subject: Re: browse lookup - spped up selection


> Dennis Malen wrote:
>> 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,
>
> I would suggest that better indexes will make the browse lookup work 
> faster.  Make the indexing so that you can select what you want by the key 
> used, if at all possible.
>
> For example,
>
>
> Cust#/Invoice#/Line#/Order
> or
> Cust#/Invoice#/Line#/Closed
>
> Then if you have to drop a few items you only have a few to look at.
>
> Nancy
> -- 
> Nancy Palmquist MOS & filePro Training Available
> Virtual Software Systems Web Based Training and Consulting PHONE: (412) 
> 835-9417    Web site:  http://www.vss3.com
>
>
>
>