Examining the current MySQL query in MLT Taxonomy with EXPLAIN shows that it always results in the use of both temporary tables and the filesort algorithm. Here is a patch that does the sorting and limiting on the result set in PHP and does not trigger those two things.

CommentFileSizeAuthor
#1 morelikethis-869730.patch4.37 KBtirdadc

Comments

tirdadc’s picture

StatusFileSize
new4.37 KB

Patch attached.