ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 33,181
- Points
- 823
We have a
The query in
Read more
Continue reading...
xf_reaction_content table with approching 200 million rows, and there seems to be an issue when reactions are rebuilt during user deletions.The query in
XF\Reaction\AbstractHandler::updateContentReactions which runs the sub-query SELECT content_id FROM xf_reaction_content WHERE content_type = ? AND reaction_user_id = ? is running it with a user ID of 0 - but there's just over 6 million rows with a user ID of 0. As this grows, this query seems to be getting...Read more
Continue reading...