Besides your points, we must also consider that MySQL does neither support hash joins nor sort/merge join. MySQL it just not very good at joining.
Nevertheless, a MySQL join should never be slower than the N+1 select approach.
Nevertheless, a MySQL join should never be slower than the N+1 select approach.
No comments yet.