> The "wikibase:label" service is know to consume and it timeouts often
imho: We can use subquery for optimization so the label service doesn’t have to do as much work https://w.wiki/9zD ( LIMIT 1000 + Labels + Descriptions ) LIMIT 10000 - 6924 results in 59861 ms ( birthday = 13 October 2014 ) LIMIT 1000 - 1000 results in 12050 ms the ideal case will be - if the sparql engine can detect and automatically optimize this type of queries. Imre Nicolas VIGNERON <vigneron.nico...@gmail.com> ezt írta (időpont: 2019. okt. 12., Szo, 19:01): > Hi, > > The "wikibase:label" service is know to consume and it timeouts often > (nothing new it happens since the beginning ; but as Wikidata grows, it's > more or more visible). > > This simplified version of the query works (without intermediate variables > and without the service): https://w.wiki/9yR > > Cheers, > ~nicolas > > Le sam. 12 oct. 2019 à 18:41, Fabrizio Carrai <fabrizio.car...@gmail.com> > a écrit : > >> I noticed few timeouts on example queries, for example >> >> Whose birthday is today ? >> <https://query.wikidata.org/#%23Di%20chi%20%C3%A8%20il%20compleanno%20oggi%3F%0A%23Whose%20birthday%20is%20today%3F%0ASELECT%20%3Fentity%20%3FentityLabel%20%3FentityDescription%20%28YEAR%28%3Fdate%29%20as%20%3Fyear%29%0AWHERE%20%7B%0A%20%20%20%20BIND%28MONTH%28NOW%28%29%29%20AS%20%3FnowMonth%29%0A%20%20%20%20BIND%28DAY%28NOW%28%29%29%20AS%20%3FnowDay%29%0A%20%20%20%20%3Fentity%20wdt%3AP569%20%3Fdate%20.%0A%20%20%20%20FILTER%20%28MONTH%28%3Fdate%29%20%3D%20%3FnowMonth%20%26%26%20DAY%28%3Fdate%29%20%3D%20%3FnowDay%29%0A%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%20%20%20%0A%7D%0ALIMIT%2010> >> >> Is it correct to have this condition ? >> -- >> *Fabrizio* >> _______________________________________________ >> Wikidata mailing list >> Wikidata@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikidata >> > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata >
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata