Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
Sonya* Posted March 7 Posted March 7 (edited) I have a community with over 30,000,000 posts. I have created achievement rules that deal: with posts timeline (registered since and logged in for X days) member's followers (not content!) Then I start rebuilding the achievement. Estimation: it will take some weeks to rebuild. What I do not understand is: why IPS tries to recount reactions, followed items and nodes and other things, if I do not have any rule based on it? E.g., the reaction table is huge (~10GB). I do not have any rule based on reaction. The rebuilding of “nothing” is strange. Those are tasks that rebuild something I have not defined: While VotePoll and JoinClub are “recalculated” pretty quickly, I estimate a very long term for rebuilding Reaction and FollowContentItem. Is it a bug? Can I stop the tasks that do not really calculate anything? Edited March 7 by Sonya*
Marc Posted March 7 Posted March 7 I would assume it would run each rule against the relevant items. So if there are no rules to be run against them, they would just complete. I have however tagged devs to confirm this
Sonya* Posted March 7 Author Posted March 7 16 minutes ago, Marc Stridgen said: I would assume it would run each rule against the relevant items. I would assume it, too. It should be reproducible. Just remove all rules that deal with reactions, start rebuilding and find a task for Reaction in the background tasks. Not a deal for small communities. But an issue for large communities. I had to stop my rebuilding after almost 2 weeks due to the “rebuilding” of reactions (almost 10 GB table). It really goes through the entire reactions, even if there are no rules that require reactions.
Recommended Posts