Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do the Mdots have it?- Attn Ken Levy
Message
 
 
To
26/04/2002 12:56:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00649450
Message ID:
00649774
Views:
18
Jim,

So if we have intense code loops to run that aren't using any table/cursor data, we should do a SELECT 0 to move to an unused work area before the code starts executing. It kinda makes sense that that would give us the highest possible preformance.

>I tested Cetin's code, and there is indeed a difference from VFP6 to VFP7.
>
>The specifics of his example show the behavior at its most pronounced. Using his example, on my PC (PIII 933) the slowdown is ~.0000011 seconds per variable per iteration.
>
>I found that the slowdown is proportional to the number of fields in the table opened in the currently selected workarea. Since his code uses 255 fields, it represents the worst case; halving that number will roughly half the amount of the increase, and so forth down to 1 field. With 1 field, or no table open in the currently selected workarea, there is basically no slowdown, or it is negligible.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform