mysql join on two indexes takes long time!!
- by Alaa
Hi All
I have a custom query in dripal, this query is:
select count(distinct B.src)
from node A, url_alias B
where concat('node/',A.nid)= B.src;
now, nid in node is primary key and i have made src as an index in url_alias table.
after waiting for more than a minute i got this:
+-----------------------+
| count(distinct B.src) | …
