Re: Related posts by tags optimization
Please provide the EXPLAIN.
Suggest you work outward from
FROM ( SELECT idTag, COUNT(*) AS relCt FROM rel_posts_tags
WHERE idPost = 34501
GROUP BY idTag
ORDER BY relCt DESC LIMIT 10 )
Subject
Views
Written By
Posted
2900
June 08, 2012 10:27AM
Re: Related posts by tags optimization
1070
June 10, 2012 10:36PM
961
June 10, 2012 11:15PM
1081
June 11, 2012 11:40PM
1040
June 12, 2012 01:50AM
944
June 12, 2012 08:58PM
1172
June 12, 2012 10:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.