>I have a very large table over 300,000 records
>
>I am using locate for command
>I can not use seek because I have conditions seek does not fulfill
>
>The first time a use the command locate,it is very slow
>
>The second time and then, locate is very fast
>
>The command is in a button of a form and table in date environment
>If I close the form, the first time I use locate it is slow again
>
>Is there any explanation for it ?
Caching. I open all tables at application startup. This benefits all subsequent table openings, even in private data session forms and sql queries.
A1=0
FOR X = 1 TO 1000
USE \\SERVER\MYUEDATA\DATA\UEMEMBERS
A=SECONDS()
LOCATE FOR UPPER(SURNAME)="YEARWOOD"
A1=M.A1+SECONDS()-M.A
ENDFOR X
?"CACHING",M.A1/1000
USE \\SERVER\MYUEDATA\DATA\UEMEMBERS
A1=0
FOR X = 1 TO 1000
A=SECONDS()
LOCATE FOR UPPER(SURNAME)="YEARWOOD"
A1=M.A1+SECONDS()-M.A
ENDFOR X
?"NO CACHING",M.A1/1000