>>>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
>
>... but did that change since FPD? Hmm.
>
>Marc
Surely, not! But VFP complains seeing bad rushmore much more that FPD:)
Edward Pikman
Independent Consultant