470818 - Slow query, looks like forum search?

Status: VERIFIED WONTFIX

(support.mozilla.org :: Forum, task)

Description

[Laura Thomson :laura]

Via justdave:
SELECT c.`title` AS name, c.`data`, c.`hits` AS hits, c.`commentDate` AS lastModif, CONCAT(f.`name`,': ',c.`title`) AS pageName, c.`parentId` AS parentId, c2.`hits` AS parentHits, c2.`title` AS topicName, c.`threadId` AS threadId, c.`userName` AS userName,f.`forumId` AS id1,c.`threadId` AS id2, MATCH(c.`title`,c.`data`) AGAINST ('use older version of firefox') AS relevance FROM (`tiki_comments` c, `tiki_forums` f) LEFT JOIN `tiki_comments` c2 ON c2.`threadId`=c.`parentId`  WHERE c.`objectType` = "forum" AND f.`forumId` = c.`object` AND f.forumId = 1 AND MATCH(c.`title`,c.`data`) AGAINST ('use older version of firefox') ORDER BY relevance desc, c.`hits`

Comment 1

[Laura Thomson :laura]

Query is in webroot/lib/searchlib.php.

Takes 35 seconds local, in this case because it returns 60-odd thousand rows.  Whacking in a limit clause brings it down to ~1 second.  I'll see what else I can find.

Comment 2

[Laura Thomson :laura]

Pushing new search will get rid of this query.  Deferring until after we've done that, and then likely INVALID.

Comment 3

[Laura Thomson :laura]

We don't use this search any more.

Comment 4

[Tom Ellins [:TMZ]]

Verified due to new search.