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
22/04/1998 10:46:30
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00093759
Message ID:
00094001
Views:
43
>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
>>


I would recommend a change in data access. The benefit of views and buffering over the old SCATTER/GATHER/REPLACE is huge.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform