M

Inefficient reaction cache rebuild on username change

  • Thread starter Thread starter mattrogowski
  • Start date Start date
M

mattrogowski

Guest

On a large forum with some 22 million posts and very high reaction usage, coupled with high volume of username changes (mostly from a high volume of account deletions), the process to update the reaction user cache on content is painfully inefficient and leads to frequent table locks that then cause performance and stability issues on the site.

We have an addon that allows users to delete their own accounts, which are queued and fed in in small batches (3 at a time one an hour) so as not...

Read more

Continue reading...
 
Similar threads Most view View more
Back
Top Bottom