Are mysql joins of tables fast or should i avoid using them on frequently accessed pages (5 hits per sec.)?
A example:
---
SELECT f.forum_name, c.cat_title
from forums f
left join categories c on c.cat_id = f.cat_id
left join x x on x.x= x.x
left join x x on x.x= x.x
---
A example:
---
SELECT f.forum_name, c.cat_title
from forums f
left join categories c on c.cat_id = f.cat_id
left join x x on x.x= x.x
left join x x on x.x= x.x
---