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

2018-10-01 Thread Smalyshev 
Smalyshev added a comment.
@Luitzen you may want to use  bd:serviceParam wikibase:limit 20 .. With it, the query runs for 335 ms for me.TASK DETAILhttps://phabricator.wikimedia.org/T177275EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: Luitzen, gerritbot, Eloquence, Aklapper, Smalyshev, CucyNoiD, 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

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

2018-10-01 Thread 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 10TASK DETAILhttps://phabricator.wikimedia.org/T177275EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Smalyshev, LuitzenCc: 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

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

2017-11-08 Thread Eloquence 
Eloquence added a comment.
Awesome, thanks very much for your work on this! Seems to work exactly as advertised and should make it possible to build some nicer suggesters with a single query.  :)TASK DETAILhttps://phabricator.wikimedia.org/T177275EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Smalyshev, EloquenceCc: gerritbot, Eloquence, Aklapper, Smalyshev, Lahi, Lordiis, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, EBjune, merbst, Avner, Lewizho99, Maathavan, debt, 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

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

2017-11-05 Thread gerritbot 
gerritbot added a comment.
Change 388287 merged by jenkins-bot:
[wikidata/query/rdf@master] Add option to fetch ordinal of the result in MWAPI query:

https://gerrit.wikimedia.org/r/388287TASK DETAILhttps://phabricator.wikimedia.org/T177275EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: gerritbot, Eloquence, Aklapper, Smalyshev, Lahi, Lordiis, Lucas_Werkmeister_WMDE, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, EBjune, merbst, Avner, Lewizho99, Maathavan, debt, 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

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

2017-11-02 Thread gerritbot 
gerritbot added a comment.
Change 388287 had a related patch set uploaded (by Smalyshev; owner: Smalyshev):
[wikidata/query/rdf@master] Add option to fetch ordinal of the result in MWAPI query:

https://gerrit.wikimedia.org/r/388287TASK DETAILhttps://phabricator.wikimedia.org/T177275EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: gerritbotCc: gerritbot, Eloquence, Aklapper, Smalyshev, Lahi, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, Avner, debt, 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