[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