>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

Igor,

All I can say is that what you tell us surprises me. VFP could be slower when you display things on screen, but on pure database accesses, I have yet to see a phenomenon as you describe it.