Scott Ambler recommends in his publication " Mapping Objects to Relational Databases" not to do joins but to traverse tables. He claims that 'several small accesses are usually more efficient than one big join'. Is that true for mysql? I am particularly interested in a scenario where I would retrieve only one row from each table involved in the join.
Thanks/h --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
