Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Please help : VFP works slower than Foxpro 2.5 for DOS
Message
From
21/04/1998 14:26:57
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00093759
Message ID:
00093764
Views:
28
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform