[thelist] SQL question: Will this require a sub-select?

r937 rudy at r937.com
Sun Sep 7 10:05:02 CDT 2008


> That means both the outer select and the sub-select
> must join all they way up to the organization table.
> So, it's going to be slower yet.

but not noticeably so

adding joins in the many-to-one direction (as in going up a hierarchy) is 
almost instantaneous, assuming proper indexes exist

your idea of saving counts and updating them after (infrequent) 
inserts/deletes is excellent


rudy 





More information about the thelist mailing list