Homestyx hydra
Diffusion hydra 204b6694af1a

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, 5:38 PM
sirocylPushed on Oct 16 2024, 5:49 AM
Parents
R1:bdcba43f212a: Formalize a mechanism for marking Conduit methods deprecated/unstable
Branches
Unknown
Tags
Unknown

Event Timeline