// slow joinless approach
SELECT *
FROM bar
WHERE id = (SELECT id
FROM foo
WHERE name='huypv')
// fast join implementaion
SELECT b.*
FROM foo f INNER JOIN bar b ON f.id=b.id
WHERE f.name='huypv
Title:
Perfomance Tuning PHP - SQL Joins
Description:
// slow joinless approach SELECT * FROM bar WHERE id = (SELECT id FROM foo WHERE name='huypv') // fast join ...
...
Rating:
4