Running a Query with in a foreach loop

[eluser]kgill[/eluser]
[quote author="Phil Sturgeon" date="1249960433"]

You COULD join the two but it makes the looping a P.I.T.A and think about it, its not going to be that much data. If a user is involved with 10,000 projects then the slow performance will be an acceptable punishment for being such an idiot.

the only performance issue here would be the full list of projects for each user, but that is why the cache was invented. :-)[/quote]

Which is why I prefaced it with in this case it's fine and explained why Mostly I was speaking in general terms not about projects. You and I know when to use which method but if you don't tell the new folk that this is a bad idea when they encounter large datasets they write inefficient code thinking that's the way it's supposed to be done.