[Wikidata-bugs] [Maniphest] [Created] T146921: GROUP, OPTIONAL and LABEL service leads to timeout

[Esc3300]

Esc3300 created this task. Esc3300 added a project: Wikidata-Query-Service. Herald added a subscriber: Aklapper. Herald added projects: Wikidata, Discovery.

TASK DESCRIPTION

Somehow the below times after once OPTIONAL {} is added:

SELECT 	
	?item ?itemLabel
	(GROUP_CONCAT(DISTINCT ?instanceLabel; separator=", ") as ?i)
	(SAMPLE(?metricalPattern) as ?mp)
WHERE 
{
	?item wdt:P31/wdt:P279* wd:Q1651051 .
	?item wdt:P31 ?instance . 
	OPTIONAL { ?item wdt:P2552 ?metricalPattern }.
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en" . ?instance rdfs:label ?instanceLabel . ?item rdfs:label ?itemLabel }
}
GROUP BY ?item ?itemLabel ?metricalPattern

try it

More complex queries work (see here. They main differences seems to be the concat on labels.

How can this be improved?

TASK DETAIL

https://phabricator.wikimedia.org/T146921

EMAIL PREFERENCES

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

To: Esc3300
Cc: Aklapper, Esc3300, mschwarzer, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331

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