Forum Post: Got asked a Newbie Question: Nested -vs- Join

[S33]

I got asked a basic question and realized I didn't know the answer: Readability aside, is there generally a performance difference between nested "for each" loops -vs- a single join? /* one way */ for each table1 break by somefield: /* do something */ for each table2 of table1: /* do something more */ end. end. /* other way */ for each table1, each table2 of table1 break by table1.somefield: if first-of(table1.somefield) then /* do something */ . /* do something more */ end. Thanks in advance -- Jim Shepherd Level 7

Continue reading...