>>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
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.