Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed issue: Set Relation .vs. Set Filter .vs. Select & Seek
Message
De
16/10/1997 17:08:45
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Speed issue: Set Relation .vs. Set Filter .vs. Select & Seek
Divers
Thread ID:
00055022
Message ID:
00055022
Vues:
117
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform