On Fri, 14 Jun 2002, kyle dawkins wrote: > bigger system, but I would also caution people to say that if you find > yourself doing joins across up to 6 tables, you're almost certainly > doing something wrong from the start and, basically, you're fooked > because of shitty design, and O/R or R/O won't help you.
This is one of the sillier statements I've seen on this list. If you have complex data with many entities (and thus many tables) and you have complex queries then you can easily find yourself joining many tables. This is hardly a sign of bad design. In fact, it may be a sign of good (normalized) design. If _all_ of your queries are against 1 table at a time, that seems a lot more worrisome to me (because it suggests insufficient or non-existent normalization). -dave /*================== www.urth.org we await the New Sun ==================*/