Fuzzy Browse Speed

[GCC Consulting]

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of Nancy Palmquist
> Sent: Friday, February 16, 2007 3:21 PM
> To: filePro List
> Subject: Fuzzy Browse Speed
> 
> I was wondering if anyone had a trick to offer to make the 
> Browse Lookup that is using a Fuzzy Search finish any faster.
> 
> I am searching a file that fundamentally has a STATE & City 
> field.  I want to find a city  that matches my input, in the 
> state I indicated.
> 
> So I enter a CSTATE code, then I enter a CITY.
> 
> I run a lookup  like this:
> 
> kk=CITY
> 
> 52  -------   -   -   -   -   -   -   -   -   -   -   -   -   
> -   -   -   -
>        ◄ If:
>        Then: lookup card = cardfile  Z=49   K=kk   -n b="(brw=12,9,-1 
> fuzzy=20 xkey=X show=pkeep pop=2 prc=matchst fill=asc)[City/Ent
> 53  -------   -   -   -   -   -   -   -   -   -   -   -   -   
> -   -    -
>        ◄ If:
>        Then: ity                     Payto                OLD 
> CITY]*49 
>                             *3                   *1"
> 54  -------   -   -   -   -   -   -   -   -   -   -   -   -   
> -   -    -
>     [These lines do what happens if I pick something or don't 
> pick something]
> 
> 
>   58  -------   -   -   -   -   -   -
> matst  ◄ If: cstate ne card(48)
>         Then: drop
>   59  -------   -   -   -   -   -   -
>         ◄ If:
>         Then: end
>   60  -------   -   -   -   -   -   -
> 
> 
> I tried DROP ALL and DROP ALL AFTER - but a fuzzy search 
> works by record 
> and I think it does not understand these options.
> 
> Anyone got an idea.
> 
> 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

NANCY,

My I assume that card(48) is a city/state field and that cstate is casted as card(48)?

If so, why not build an index on this field?

As an aside, I found that for remote logins using terminal server, with an indexed browse

If: file(xx) lt nnnn
Then:Drop all before;end
If: file(xx) gt nnnn
Then:Drop all after;end

Is slightly faster then

If: file(xx) ne nnnn
Then: drop all;end

I timed this using a 34,000 plus data file needing to select records matching the 4 digit number.

I can't tell you why this is so, but it is.  This was in the order of 5 to 10 second difference in presenting records.