[Wikidata-bugs] [Maniphest] [Created] T195490: Use CirrusSearch for PropertySuggester

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE created this task. Lucas_Werkmeister_WMDE added projects: Wikidata, MediaWiki-extensions-PropertySuggester. Herald added a subscriber: Aklapper.

TASK DESCRIPTION

PropertySuggester’s SuggestionGenerator directly uses TermSqlIndex::getTopMatchingTerms(), resulting in queries like this (slightly reformatted from T194273#4228564):

SELECT term_entity_type, term_type, term_language, term_text, term_weight, term_full_entity_id 
FROM `wb_terms`
WHERE
term_language = 'en'
AND (term_text LIKE 'b%' ESCAPE '`')
AND term_type IN ('label','alias')
AND term_entity_type = 'property'
LIMIT 2500

This should use CirrusSearch instead, so that we don’t have to keep expensive indexes on term_text/term_search_key.

TASK DETAIL

https://phabricator.wikimedia.org/T195490

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lucas_Werkmeister_WMDE
Cc: Aklapper, Lucas_Werkmeister_WMDE, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Sjoerddebruin, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs