browse lookup - spped up selection

Nancy Palmquist nlp at vss3.com
Fri Apr 14 12:29:02 PDT 2006


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



More information about the Filepro-list mailing list