aude added a comment.

by comparison, term queries are significantly slower

SlowTimer [60001ms] at runtime/ext_mysql: slow query: SELECT /* 
Wikibase\TermSqlIndex::getMatchingTerms */  
term_entity_type,term_type,term_language,term_text,term_weight,term_entity_id  
FROM `wb_terms`   WHERE ((term_language = 'en' AND (term_search_key LIKE 'foo%' 
) AND term_type = 'label' AND term_entity_type = 'item') OR (term_language = 
'en' AND (term_search_key LIKE 'unchar%' ) AND term_type = 'alias' AND 
term_entity_type = 'item'))  LIMIT 5000


TASK DETAIL
  https://phabricator.wikimedia.org/T111769

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

To: aude
Cc: daniel, jcrespo, aude, Aklapper, Wikidata-bugs, GWicke, Krenair



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

Reply via email to