Talk:Wikidata Query Service/Problematic queries
Add topicLatest comment: 3 years ago by Tom.Reding in topic LIMIT+OFFSET apparently not working as intended
You can add your candidates here. Please see also:
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_limits
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_optimization
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/suggestions#Performance_surprises
LIMIT+OFFSET apparently not working as intended
[edit]I'm trying to get a list of all en.wiki articles using GND ID (P227), which is ~350,000. I'm unable to obtain the last 50,000 via this query due to timeout, despite using LIMIT 50000 OFFSET 300000. I'm trying to perform this same search for ISNI (P213), Library of Congress authority ID (P244), P7859 (P7859), VIAF ID (P214), but repeatedly get timed out beyond 300,000. ~ Tom.Reding (talk ⋅dgaf) 14:21, 17 February 2021 (UTC)