Answer the question
In order to leave comments, you need to log in
Which of these two queries is faster/more performant?
These two queries give me what I need.
SELECT d.id, d.author_id, d.msg, d.added_time, u.name AS author_name
FROM discussion_messages AS d, people AS u
WHERE u.id=d.author_id AND d.discussion_id=?
SELECT d.id, d.author_id, d.msg, d.added_time, u.name AS author_name
FROM discussion_messages d
LEFT JOIN people u ON u.id=d.author_id
WHERE d.discussion_id=?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question