Wrote a bunch of #GoToSocial code today and yesterday to store account stats in a separate db table, which brings some nice advantages like being able to easily store correct followers/following/statuses counts from remote instances :)
https://github.com/superseriousbusiness/gotosocial/pull/2831
Should also help with slow COUNT queries for postgres users, since counts will be done less often than before.
Kapow!
[feature/performance] Store account stats in separate table by tsmethurst · Pull Request #2831 · superseriousbusiness/gotosocial
Description If this is a code change, please include a summary of what you've coded, and link to the issue(s) it closes/implements. If this is a documentation change, please briefly describe what ...GitHub