I created a view that is a join between two tables a.2_9 (18.483 rows) and b.2_10 (5700 rows)
it is a very simple join:
Create view v_2_9_join_2_10 AS
Select *
FROM 2_9 AS a
LEFT JOIN 2_10 b
ON a.2_9_tid = b.2_10_tid
AND a.2_9_region = b.2_10_region
AND a.n_2 = b.n_2
I to create the view and count the rows (18483) but for some reason it takes forever when I try to use the view, count or export or just browse and it is slowing down the database in PHP too much.
Any ideas of how I can look for the reason(s) of the slowing down or optimize the join?