Unfortunately I just tried again with a limit of 10 and I got a timeout
anyhow.
I agree it is an example, but do we have to say that some queries could
never run on wikidata? I don't know if there are some other query
tool/methods to got the results?
Thanks
Fabrizio
Il mar 15 ott 2019, 11:02 BOISSEL Sylvain <sylvain.boissel(a)wikimedia.fr> ha
scritto:
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
--
*Sylvain Boissel*
ADMINISTRATEUR SYSTÈME ET RÉSEAUX
*WIKIMÉDIA FRANCE*
*Tél: ** +33 9 67 45 12 67*
*Mobile : +33*
* 7 84 37 91 03*
*www.wikimedia.fr <http://www.wikimedia.fr/>*
*40 rue de Cléry, **75002 Paris*
<http://www.openstreetmap.org/node/691082430#map=19/48.86814/2.34683>
*Imaginez un monde où chaque personne sur la planète aurait librement
accès à la totalité du savoir humain. C'est notre engagement. Aidez
Wikimedia France à en faire une réalité <https://dons.wikimedia.fr>.*
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 ?
Thanks
Fabrizio
Il giorno dom 13 ott 2019 alle ore 04:05 Imre Samu <pella.samu(a)gmail.com>
ha scritto:
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.nicolas(a)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.carrai(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
--
*Fabrizio*
_______________________________________________
Wikidata mailing
listWikidata@lists.wikimedia.orghttps://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________
Wikidata mailing list
Wikidata(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata