If adding a LIMIT makes the query work, we can just edit the example to have the said limit. It is only an example query, it doesn't have to return all the results.
Cheers,
Sylvain
Le 2019-10-13 08:56, Fabrizio Carrai a écrit :
Thanks all for the explanations, now my point is on the examples as seen by some first Wikidata users: if the examples are there and fail, that's disappointing.Have we to comment out examples that could fail ? Should we mark this ?I don't like the latter, but if it is a contingent situation it makes sense.Till the work load is not managed, e.g. by optimizations, can we increase the timeout ?ThanksFabrizio
Il giorno dom 13 ott 2019 alle ore 04:05 Imre Samu <pella.samu@gmail.com> ha scritto:> The "wikibase:label" service is know to consume and it timeouts oftenimho: We can use subquery for optimization so the label service doesn’t have to do as much workLIMIT 10000 - 6924 results in 59861 ms ( birthday = 13 October 2014 )https://w.wiki/9zD ( LIMIT 1000 + Labels + Descriptions )
LIMIT 1000 - 1000 results in 12050 msthe ideal case will be - if the sparql engine can detect and automatically optimize this type of queries.Imre
_______________________________________________Nicolas VIGNERON <vigneron.nicolas@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/9yRCheers,~nicolas
Le sam. 12 oct. 2019 à 18:41, Fabrizio Carrai <fabrizio.carrai@gmail.com> a écrit :I noticed few timeouts on example queries, for example_______________________________________________
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
--
Fabrizio
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata