It this thread:
viewtopic.php?f=1&t=121692
Josh, McInfo, and DigitalMind stated that breaking joins into multiple queries was better, after I asserted the opposite. Their explanation satisfied me. But, I have encountered several places in POEAA (Fowler) that appear to contradict this. Examples are on 266 (paragraph 1), 256 (paragraphs 2 & 3), and 243 (paragraph 3). There are probably other examples that I've forgotten about, and more that I haven't read yet
I'm sure that both parties know what they are talking about, and there's some subtle difference/performance improvement I haven't caught. Perhaps someone could clarify for me?