RSS Feed/News Inefficient reaction cache rebuild on username change

[ENXF NET]

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...