[Wikidata-bugs] [Maniphest] [Commented On] T177275: Add ordinal variable to MWAPI service calls

[Luitzen]

Luitzen added a comment.

It seems that ORDER BY ?ordinal in combination with mwapi:srlimit leads to perfomance degradation. Try the following with and without bd:serviceParam mwapi:srlimit 20 (or "20"):

SELECT * WHERE {
  SERVICE wikibase:mwapi {
      bd:serviceParam wikibase:api "Search" .
      bd:serviceParam wikibase:endpoint "www.wikidata.org"  .
      bd:serviceParam mwapi:srsearch "Merkel" .
      bd:serviceParam mwapi:srlimit 20 .
      ?item wikibase:apiOutputItem "@title" .
      ?ordinal wikibase:apiOrdinal true .
  }
  ?item wdt:P31 ?type .
} ORDER BY ASC (?ordinal) LIMIT 10

TASK DETAIL

https://phabricator.wikimedia.org/T177275

EMAIL PREFERENCES

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

To: Smalyshev, Luitzen
Cc: Luitzen, gerritbot, Eloquence, Aklapper, Smalyshev, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, EBjune, merbst, LawExplorer, Avner, Lewizho99, Maathavan, Gehel, Jonas, 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