HomePhorge

Improve performance of empty search

Description

Improve performance of empty search

Summary:
Searching for empty query kills us because whole search_document table is read in this case.

This diff adds an index just for this query.

Other solution would be to disable searching for empty string. But it can be actually useful (listing newest documents of any type).

Test Plan:

EXPLAIN SELECT document.phid, document.documentType, document.documentTitle, document.documentCreated
FROM `search_document` document
GROUP BY document.phid
ORDER BY documentCreated DESC
LIMIT 0, 21;

Reviewers: epriestley

Reviewed By: epriestley

CC: jungejason, aran, Koolvin

Differential Revision: https://secure.phabricator.com/D2277

Details

Provenance
vranaAuthored on Apr 18 2012, 2:38 PM
themackabuPushed on Mar 25 2025, 8:07 PM
Parents
rPbdcba43f212a: Formalize a mechanism for marking Conduit methods deprecated/unstable
Branches
Unknown
Tags
Unknown

Event Timeline