Nikki added a comment.
In T302189#7848616 <https://phabricator.wikimedia.org/T302189#7848616>, @MPhamWMF wrote: > Thanks for the clarification. With regard to orphaned nodes throwing off query results, there should be ways to write SPARQL queries in such a way that they ignore these nodes. If it's possible to exclude orphaned nodes in a query, it must be possible to write queries which //find// orphaned nodes. Why not have a maintenance script to query for orphaned nodes and clean them up, and run it on a regular basis without being dependent on a full reload? It would be more understandable to me if orphaned nodes were cleaned up once a day or so - not real time, but still within a reasonable time frame. I'm not able to fix my own queries though, due to the query timeouts. e.g. how can I fix this query <https://query.wikidata.org/#select%20%3Fglobe%20%28count%28%2a%29%20as%20%3Ftotal%29%20%7B%0A%20%20%5B%5D%20wikibase%3AgeoGlobe%20%3Fglobe.%0A%7D%20group%20by%20%3Fglobe%20order%20by%20desc%28%3Ftotal%29>? As it is, it runs in under a second but returns incorrect data. When I try to make sure the value node exists, e.g. like this <https://query.wikidata.org/#select%20%3Fglobe%20%28count%28%2a%29%20as%20%3Ftotal%29%20%7B%0A%20%20%3Fwdv%20wikibase%3AgeoGlobe%20%3Fglobe.%0A%20%20%3Fs%20%3Fp%20%3Fwdv.%0A%7D%20group%20by%20%3Fglobe%20> or like this <https://query.wikidata.org/#select%20%3Fglobe%20%28count%28%2a%29%20as%20%3Ftotal%29%20%7B%0A%20%20%3Fs%20%3Fp%20%5B%20wikibase%3AgeoGlobe%20%3Fglobe%20%5D.%0A%7D%20group%20by%20%3Fglobe%20>, I get a timeout. I have the same problem with `wikibase:timePrecision`. (Here's <https://query.wikidata.org/#select%20%2a%20%7B%0A%20%20%3Fwdv%20wikibase%3AgeoGlobe%20%3Fglobe.%0A%20%20minus%20%7B%20%5B%5D%20%3Fp%20%3Fwdv%20%7D%0A%7D%20limit%2010000> 10,000 nodes to clean up, the most I could get without it timing out. Here's <https://query.wikidata.org/#select%20%2a%20%7B%0A%20%20%3Fwdv%20wikibase%3AgeoGlobe%20%3Fglobe.%0A%20%20filter%20%28%3Fglobe%20%21%3D%20wd%3AQ2%29.%0A%20%20minus%20%7B%20%5B%5D%20%3Fp%20%3Fwdv%20%7D%0A%7D> another 107 where the globe isn't Q2) TASK DETAIL https://phabricator.wikimedia.org/T302189 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Nikki Cc: Nikki, RP88, HenkvD, MPhamWMF, Bugreporter, dcausse, Aklapper, Yair_rand, Astuthiodit_1, AWesterinen, karapayneWMDE, Invadibot, maantietaja, CBogen, ItamarWMDE, Akuckartz, Jcross, JFishback_WMF, Nandana, Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Bawolff, Manybubbles, Slaporte, csteipp, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected]
