[Wikidata-bugs] [Maniphest] [Created] T212933: Optimize SERVICE wikibase:label

[abian]

abian created this task. abian added projects: Wikidata-Query-Service, Wikidata. Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION

The following SPARQL query runs in less than 1 second...

SELECT ?item ?itemLabel WHERE {
  {
    SELECT ?item WHERE { ?item wdt:P31 wd:Q5. }
    LIMIT 10
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

... while the following query, which is equivalent but much simpler and common, runs in more than 17 seconds...

SELECT ?item ?itemLabel WHERE {
  ?item wdt:P31 wd:Q5.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 10

There's no point in having SERVICE wikibase:label optimized for the first case, we need a cleverer implementation that doesn't cause unnecessary timeouts. This optimization becomes more necessary as the number of triples grows.

TASK DETAIL

https://phabricator.wikimedia.org/T212933

EMAIL PREFERENCES

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

To: abian
Cc: abian, Aklapper, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, D3r1ck01, Jonas, Xmlizer, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331

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