>I ran listed below small programm in VFP 5.0 and it took 94 seconds !!! In Foxpro 2.5 for DOS it took only 3 seconds !!!
>The programm and tables are located on a network drive.
>Please, help me to find a reasonable explanation of this mistery.
>
>Sincerely, Igor Gelin, System Developer
>
>
>SET EXCL OFF
>lClaimFrom="800700"
>lClaimTo="806300"
>nTotal=0
>
>Select 0
>USE ("f:\ENCO") ALIAS INST INDEX ("f:\ENCONUM")
>
>Set NEAR ON
>Seek Alltrim(lClaimFrom)
>Set NEAR OFF
>nTemp=Seconds()
>Count For !Deleted() While ENUM <= lClaimTo To nTotal
>Wait window Str(Seconds()-nTemp)+"seconds."
>
>Use In INST
Only FOR expression is Rushmore optimizable, i.e., if you have tag on ENUM, try to run COUNT FOR Enum<=lClaimto
Edward Pikman
Independent Consultant