Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Please help : VFP works slower than Foxpro 2.5 for DOS
Message
 
To
21/04/1998 14:26:57
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00093759
Message ID:
00093782
Views:
29
Hi Ed.

Your suggestion works! But it means that Rushmore optimisation in VFP and FP for DOS work totally different making me redesign not only forms but also data access in my system. It may not be good.
Sincerely, Igor Gelin

>Only FOR expression is Rushmore optimizable, i.e., if you have tag on ENUM, try to run COUNT FOR Enum<=lClaimto


>>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 Gelin
Database Developer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform