JanZerebecki added a comment. This query modified for pol instead of p still takes 12s on the analytics slave (down from about 16s for p). With 4 letters it goes below 4seconds.
There is an index named tmp1 over term_language, term_type, term_entity_type, term_search_key on that table, which is not in the source (we might want to fix that). TASK DETAIL https://phabricator.wikimedia.org/T77898 REPLY HANDLER ACTIONS Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign <username>. To: Wikidata-bugs, JanZerebecki Cc: Aklapper, JanZerebecki, Wikidata-bugs, aude _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
