browse lookup - spped up selection

Kenneth Brody kenbrody at bestweb.net
Thu Apr 13 15:21:08 PDT 2006


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