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

Click here to load this message in the networking platform