Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do the Mdots have it?- Attn Ken Levy
Message
From
04/05/2002 22:42:20
 
 
To
25/04/2002 22:15:50
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00649450
Message ID:
00652854
Views:
22
Seems to me everyone is missing the test that might be more critical. Running through a loop assigining values to variables isn't something I do, but I sure do this a lot.
select * ;
  from t1 ;
  where dfield <= m.ldDate

vs
select * ;
  from t1 ;
  where dfield <= ldDate
I ran this test where the filter produces about 32,000 records and the m.ldDate filter averaged about 5.4 seconds and the ldDate filter averaged about 5.8 seconds.



>Ken
>
>Reputable people report that use of m. nomenclature on the right side of variable assignment is far faster in VFP7 than m.-less syntax.
>
>I.e.
>
>
>myvar=m.lcMyOtherVar
>
>
>is much faster than
>
>
>myvar=lcMyOtherVar
>
>
>The difference is not that using m. is now faster; the difference is that NOT using m. is much slower than it used to be with VFP6.
>
>Those of us who deliberately changed to hungarian notation seem to be disadvantaged.
>
>Why has this happened? Is there a new feature/benefit that causes this as a side effect?
>
>Regards
>
>JR
Bill Morris
Previous
Reply
Map
View

Click here to load this message in the networking platform