[Wikidata-bugs] [Maniphest] [Commented On] T179879: Provide a 5-minute timeout in WDQS for trusted users using OAuth

[Lucas_Werkmeister_WMDE]

Lucas_Werkmeister_WMDE added a comment.

@doctaxon use MINUS instead of FILTER NOT EXISTS, and stop killing the optimizer, and then %subquery runs in less than 5 seconds.

SELECT ?item ?sitelinks WHERE {
  ?item wdt:P27 wd:Q183;
        wdt:P21 wd:Q6581072;
        wdt:P31 wd:Q5;
        wikibase:sitelinks ?sitelinks.
  MINUS {
    ?article schema:about ?item;
             schema:isPartOf <https://de.wikipedia.org/>.
  }
}

It only returns some two thousand results, so the surrounding query shouldn’t be a problem either…

TASK DETAIL

https://phabricator.wikimedia.org/T179879

EMAIL PREFERENCES

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

To: Lucas_Werkmeister_WMDE
Cc: chasemp, Lydia_Pintscher, Magnus, MichaelSchoenitzer_WMDE, MisterSynergy, doctaxon, Jonas, Ash_Crow, Daniel_Mietchen, Lucas_Werkmeister_WMDE, Jane023, Base, Gehel, Smalyshev, Ijon, Aklapper, Lahi, Gq86, Darkminds3113, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, Avner, FloNight, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331

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