| Jheald added a comment. |
Some queries:
Count of the number of uses of the property -- takes over 10 seconds
SELECT (COUNT(?ref) AS ?count) WHERE {
?ref pr:P854 ?refURL .
}Attempt to extract some references to Le Figaro website -- fails -- though it does seem to try to be creating a JSON list of something
SELECT ?ref ?refURL WHERE { ?ref pr:P854 ?refURL . FILTER (CONTAINS(str(?refURL),'lefigaro.fr')) . } LIMIT 200Attempt to use STRSTARTS to possibly save time in the string searching -- fails -- error console appears to contain a similar broken JSON list as before
SELECT ?ref ?refURL WHERE { ?ref pr:P854 ?refURL . FILTER (STRSTARTS(str(?refURL),'http://www.lefigaro.fr')) . } LIMIT 200Attempt just to count the number of such instances -- still times out
SELECT (COUNT(?ref) AS ?count) WHERE { ?ref pr:P854 ?refURL . FILTER (STRSTARTS(str(?refURL),'http://www.lefigaro.fr')) . }Attempt to find a meaningless string, to simulate a website used very few times -- still fails to complete
SELECT ?ref ?refURL WHERE { ?ref pr:P854 ?refURL . FILTER (STRSTARTS(str(?refURL),'http://www.pqrstuvwxyz')) . } LIMIT 200The first search for Le Figaro used to work -- back when the WDQS SPARQL service was first enabled.
I don't know if something has changed since then in BlazeGraph or the WDQS set-up, or whether I am seeing this just because the number of uses of P:854 may have increased since that time; but not being able to extract at scale the items that reference particular sources makes the property and its data very much less useful.
Cc: Aklapper, Jheald, EBjune, merbst, Avner, debt, Gehel, D3r1ck01, Jonas, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
