Slow query, looks like forum search?

VERIFIED WONTFIX

Status

support.mozilla.org
Forum
VERIFIED WONTFIX
9 years ago
8 years ago

People

(Reporter: laura, Assigned: laura)

Tracking

unspecified
Future

Firefox Tracking Flags

(Not tracked)

Details

(Assignee)

Description

9 years ago
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`
(Assignee)

Comment 1

9 years ago
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.
(Assignee)

Updated

9 years ago
Target Milestone: 0.8.1 → 0.8.2
(Assignee)

Updated

9 years ago
Target Milestone: 0.8.2 → 0.9
(Assignee)

Comment 2

9 years ago
Pushing new search will get rid of this query.  Deferring until after we've done that, and then likely INVALID.
Severity: critical → normal
Target Milestone: 0.9 → Future
(Assignee)

Comment 3

9 years ago
We don't use this search any more.
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → WONTFIX

Comment 4

8 years ago
Verified due to new search.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.