Mattias Thorslund wrote:

> Though, (regardless of SQL database platform) in a case like this, it
> MAY be both more straightforward and efficient to use two separate
> queries for the pictures and comments, given the one-to-many cardinality
> between them.  The above statement causes redundant data to be returned
> - it duplicates the pics record for each new comment.  If there are many
> large columns in the pics table and many comments to each record there's
> a lot of redundant data in a query like that.

No, I think you are wrong. There was GROUP BY pics.id so it won't return
duplicate data. And probable overhead is eliminated too I think - DBserver
will optimize and will join data from pic_comments only once for each
unique pics.id.

Lenar

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to