odd results with scan search

Nancy Palmquist nlp at vss3.com
Thu Nov 19 12:08:19 PST 2015


Bruce,

On 11/19/2015 11:28 AM, Bruce Easton via Filepro-list wrote:
> In a file where a field contains "Lyon" and I scan for records using 
> extended selection and ask for records containing (co) "yon", some 
> results are returned that include the records with name "Lyon". 
> However, if I search the same file on another field for "DPM" and some 
> records exist where that field contains "xxx/DPM", no results are 
> returned.  This is with filepro 5.0.13.
>
The important part of the answer is if you have index scan on or off, 
paired with that is if the field you are scanning is indexed and the 
field length is total in the index.

If the field is indexed, and you have scan/select ON (default behavior) 
then the search is done on the index not the real data. Try turning the 
index scan off by using -jn on the command line. Try it then.

I can not remember if there is an environment variable to turn off index 
scan in the environment.

If the index is built on less than the entire field or it is corrupt, 
that could explain your scanning issue.

Using Index scan can be much much faster but the index has to be 
reliable.  I am not sure if the CONTAINS method might affect your index 
scan results somehow.

Nancy

> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>

-- 
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