sarhan.alaa added a comment.
oh yeah sure that won't be running in production like that .. I just was wondering if there are any extra optimization here that I could've missed re using indexes or using the sub-queries. re running in batches, sure it should limit deleting to an acceptable amount.. and as long as we run frequently enough, then it shouldn't be an issue for both retaining deleted data for long nor for performance. thanks @Addshore for the feedback, I'll submit a production-ready batch to get more feedback on a final solution there TASK DETAIL https://phabricator.wikimedia.org/T220150 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: sarhan.alaa 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 Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs