Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed issue: Set Relation .vs. Set Filter .vs. Select &
Message
From
16/10/1997 20:14:53
 
 
To
16/10/1997 17:08:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00055022
Message ID:
00055053
Views:
27
>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.

Peter;
Try to stay away from FILTER as much as possible. In dealing with child records, I usually use the SELECT command and include RECNO() as a column. Then use the record number to point directly to the record in the child table.

Hope this helps
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform