Ladsgroup created this task. Ladsgroup added a project: Wikidata. Restricted Application added a subscriber: Aklapper. |
TASK DESCRIPTION
Found this in tendril slow queries.
SELECT /* Wikibase\Repo\Store\Sql\SqlEntitiesWithoutTermFinder::getEntitiesWithoutTerm*/ page_title AS `entity_id_serialization` FROM `page` LEFT JOIN `wb_terms` ON (((term_entity_type = 'item' AND page_namespace = '0' AND (term_full_entity_id = page_title))) AND term_type = 'label' AND term_language = 'en') WHERE (term_entity_type IS NULL) AND page_is_redirect = '0' AND page_namespace = '0' ORDER BY page_id DESC LIMIT 50000000, 51
Offsetting like this is discouraged in mysql and it's pretty slow. Rebuild the query.
TASK DETAIL
EMAIL PREFERENCES
To: Ladsgroup
Cc: Aklapper, WMDE-leszek, Addshore, Lydia_Pintscher, Ladsgroup, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331
Cc: Aklapper, WMDE-leszek, Addshore, Lydia_Pintscher, Ladsgroup, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs