Skip navigation links

MySQL Forums :: Performance :: Related posts by tags optimization


Advanced Search

Re: Related posts by tags optimization
Posted by: Rick James ()
Date: June 10, 2012 10:36PM

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 )

Options: ReplyQuote


Subject Views Written By Posted
Related posts by tags optimization 1214 René Olivo 06/08/2012 10:27AM
Re: Related posts by tags optimization 480 Rick James 06/10/2012 10:36PM
Re: Related posts by tags optimization 507 René Olivo 06/10/2012 11:15PM
Re: Related posts by tags optimization 514 Rick James 06/11/2012 11:40PM
Re: Related posts by tags optimization 574 René Olivo 06/12/2012 01:50AM
Re: Related posts by tags optimization 469 Rick James 06/12/2012 08:58PM
Re: Related posts by tags optimization 571 René Olivo 06/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.