browse lookup - spped up selection
Dennis Malen
dmalen at malen.com
Thu Apr 13 15:26:56 PDT 2006
What command am I using to execute a selection set before I get to the
browse lookup processing?
Dennis
----- Original Message -----
From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "Dennis Malen" <dmalen at malen.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Thursday, April 13, 2006 6:21 PM
Subject: Re: browse lookup - spped up selection
> Quoting Dennis Malen (Thu, 13 Apr 2006 17:56:11 -0400):
> [...]
>> 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.
>
> Well, if you need to use processing in conjunction with the browse
> lookup to further refine the records that display, the way to speed
> it up is to speed up your processing.
>
> If you have a selection set that can do it for you, then simply use
> the selection set in your processing to help the filtering process.
>
> --
> KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com
>
>
>
More information about the Filepro-list
mailing list