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 15:12:34
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00093759
Message ID:
00093786
Views:
29
Not totally, but somewhat different, and it helps to find developer's blunders :). Actually, MS said that VFP engine has changed and not all things are the same as for FPD. About 1.5 year ago we had extensive UT discussion on this topic.

>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
>>
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform