Jheald created this task. Jheald added a subscriber: Jheald. Jheald added a project: Wikidata-Query-Service. Herald added subscribers: StudiesWorld, Steinsplitter, Aklapper. Herald added projects: Wikidata, Discovery.
TASK DESCRIPTION SPARQL queries involving sitelinks are very slow, to the point that it is often impossible to write a query involving sitelinks without the WDQS service timing out. For example [[ http://tinyurl.com/j8gflg6 | this query ]], that tries to count the number of Wikidata category-items that have Commons sitelinks, does not complete: ``` PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX schema: <http://schema.org/> SELECT (COUNT(DISTINCT ?sitelink) AS ?count) WHERE { ?item wdt:P31 wd:Q4167836 . ?sitelink schema:about ?item . ?sitelink schema:inLanguage "en" . FILTER (STRSTARTS(str(?sitelink), "https://commons.wikimedia.org/";)) . } ``` In contrast, a [[ http://tinyurl.com/hxskcny | similar-sized query ]] that does not involve sitelinks completes without trouble: ``` PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX schema: <http://schema.org/> SELECT (COUNT(DISTINCT ?commonscat) AS ?count) WHERE { ?item wdt:P31 wd:Q4167836 . ?item wdt:P373 ?commonscat } ``` It would seem that the issue could be resolved by adding new statements to the triplestore, of the form ``` ?item wikibase:hasSitelinkTo wd:Q565 ``` where in this case Q565 is the item for Wikimedia Commons TASK DETAIL https://phabricator.wikimedia.org/T120198 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Jheald Cc: Aklapper, Steinsplitter, StudiesWorld, Jheald, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331 _______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
