[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.

In T179879#4041380, @MichaelSchoenitzer wrote:

Maybe you see any other tricks to improve this type of query?

Adding a query hint helps:

SELECT ?item ?sitelinks WHERE {
  ?item wdt:P31 wd:Q5;
        wikibase:sitelinks ?sitelinks. hint:Prior hint:rangeSafe true. # tell BlazeGraph that we’re not mixing ints/floats/whatever here
  FILTER(?sitelinks >= 40)
  MINUS { ?item ^schema:about/schema:isPartOf <https://de.wikipedia.org/> }
}
ORDER BY DESC(?sitelinks)
LIMIT 10

However, you still need the FILTER, unfortunately.

TASK DETAIL

https://phabricator.wikimedia.org/T179879

EMAIL PREFERENCES

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

To: Lucas_Werkmeister_WMDE
Cc: MichaelSchoenitzer, Edgars2007, 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