alaa_wmde added a comment.
Explored in detail with @Ladsgroup .. a script that tries to identify all orphans will end up doing a full table scan. That's the case in the snippet approach in a previous comment. As pointed out by @Addshore, we will have to go with a solution that uses the information about which terms have been updated/deleted as part of the write operation. The actual clean-up will happen in a triggered post-request job, but it should be passed the terms(ids) that have been touched. TASK DETAIL https://phabricator.wikimedia.org/T220150 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: alaa_wmde Cc: sarhan.alaa, Ladsgroup, Addshore, alaa_wmde, Aklapper, JeroenDeDauw, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
