M

Inefficient reaction cache rebuild on username change

  • Thread starter Thread starter mattrogowski
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
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 content Most view View more
Back
Top Bottom