[14:03:08] !admin@wikidata please block https://www.wikidata.org/wiki/Special:Contributions/88.18.201.212 , vand on various items [14:03:32] !admin ^ [14:03:32] Please visit https://www.wikidata.org/wiki/WD:AN [14:05:01] done [14:05:25] thx [14:05:30] np [15:05:25] [Q] Is there any guide on optimization of SPARQL queries? I'm asking this because I keep getting "Query timeout limit reached". This is the query that I want to execute: http://0x0.st/-gRG.sparql [15:13:02] there is https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/query_optimization [15:13:21] but it's black magic [15:17:47] rdrg109 (in case you check the logs): this is the best I can do https://w.wiki/4BeA [15:18:11] forcing the query service to run the query in a specific order (find all the authors first, then their books) [15:18:35] and also using “country” instead of recursive “located in the administrative territorial entity” for the place of birth being in Peru [15:18:43] which is hopefully close to what you wanted [15:19:01] using “country of citizenship” for the ?author is even faster, but also probably farther away from your intention [15:19:54] i wonder if that also suffers from sudden death if you try to make it a subquery [15:20:23] inductiveload: re “it’s black magic”, apparently someone swapped out the image where I’d made that same joke? https://www.wikidata.org/w/index.php?title=Wikidata:SPARQL_query_service/query_optimization&diff=1505300107&oldid=1391672234&diffmode=source [15:20:26] idk why [15:20:31] I thought it was funny [15:20:54] joke? [15:21:11] you mean i bought this dead badget for nothing? [15:21:13] *badger [15:21:16] :D [15:22:39] you really want to be using a raccoon, not a badger [15:22:42] easy mistake to make [15:23:11] that only works in north america [15:23:28] it's due to the indian burial grounds affecting the ley lines [15:23:37] hmm that totally worked https://w.wiki/4BeK [15:24:07] huh, didn’t even need a named subquery [15:25:00] inductiveload: wdym with "it's black magic". I'm not english native speaker. Does that mean that it is a very complex topic? [15:25:25] it means complicated and no one really knows how it works [15:25:39] you just say some spells and hope you don't die [15:26:31] and yet this subquery died completely: https://w.wiki/4BeP [15:27:01] but the subquery on its own is < 1s: https://w.wiki/4BeR [15:27:43] Blazegraph is a riddle wrapped in a mystery inside an enigma [15:43:19] inductiveload: Thanks. Thanks! [15:44:03] I only intended to write one "Thanks". I have never written "Thanks" twice. [15:44:20] you have now! [15:44:44] You're welcome. You're welcome! [15:45:13] :D