Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed issue: Set Relation .vs. Set Filter .vs. Select &
Message
 
To
16/10/1997 17:08:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00055022
Message ID:
00055160
Views:
29
The only real test is to program them all and time them (using the seconds() function, maybe)...that should be easy enough and will give you a definite answer...

Joe

>I want to maximize the speed of performing calculations in related tables. I will be performing a REPLACE on every record in the child table based on values in the Parent record. Any thoughts on the best performers ?
>
>1) Using Set Relation to 'automate' finding records in child tables
>
>2) Using Set Filter to 'manually' SKIP thru records in child tables based on Parent key.
>
>3) Using Scan For in child table based on Parent key.
>
>4) Using good old fashion Seek in the Child table based on Parent key.
Joseph C. Kempel
Systems Analyst/Programmer
JNC
Previous
Reply
Map
View

Click here to load this message in the networking platform