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:27:18
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00093759
Message ID:
00093795
Views:
27
>>>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
>
>... but did that change since FPD? Hmm.
>
>Marc

Surely, not! But VFP complains seeing bad rushmore much more that FPD:)
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform