[Wikidata-bugs] [Maniphest] [Commented On] T189941: query wikidata crash and shows time out

[Mbch331]

Mbch331 added a comment.

There is too much data returned for the query service to handle within the timelimit.
A little optimization for your query:

PREFIX schema: <http://schema.org/>
SELECT ?item ?enarticle ?linkcount ?itemLabel WHERE { {
SELECT ?item ?enarticle (COUNT(DISTINCT ?sitelink) AS ?linkcount) WHERE {
  ?item (wdt:P31/wdt:P279) wd:Q486972.
  ?sitelink schema:about ?item.
  ?item wdt:P17 wd:Q668.
  OPTIONAL {
    ?enarticle schema:about ?item.
    ?enarticle schema:isPartOf <https://en.wikipedia.org/>.
  }
  MINUS {
    ?article schema:about ?item.
    ?article schema:inLanguage "fa".
    ?article schema:isPartOf <https://fa.wikipedia.org/>.
  }
}
GROUP BY ?item ?itemLabel ?enarticle
ORDER BY DESC(?linkcount)
}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fa". }
}

By moving the label service outside the main query, it first matches the main query and then it fetches the labels for the results. Otherwise it fetches the label for all items before filtering them.

This isn't an error, but just a limitation of the query service to prevent 1 query to run that long that other queries have to wait in the queue.

TASK DETAIL

https://phabricator.wikimedia.org/T189941

EMAIL PREFERENCES

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

To: Mbch331
Cc: Mbch331, Aklapper, Wikidata-Query-Service, Yamaha5, Lahi, Gq86, Darkminds3113, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, Gehel, Jonas, FloNight, Xmlizer, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles

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