What is faster, left join or 2 queries?

Databases
1

Is it almost always faster to use left join insted of using to have 2 queries? I need to display user (firstname, lastname, image and hobbies). First 3 data are from the same table, hobbies are in other table.

I presume that in this case left join is much better, am I right? And what is in generall a better choice?

2

Well, I see no reason to not use a join in the query. Otherwise you’ll have to mess with doing so in your php code, correct?

3

i can think of one scenario where the join is not advised… Minimize Bandwith in One-to-Many Joins

:slight_smile:

4

Wow, I never thought of using UNIONS like that. I’ll have to scour that site to see if there are more handy tricks :slight_smile: