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