After a morning of slow query logging and cussing, a misplaced "GROUP BY" that was turning a 0.04 second query into one that took over fifteen seconds has been fixed. I'll leave the slow query log running overnight though just to make sure I didn't miss any less common ones. If you're still seeing any serious site slowdowns, let us know.
(Score: 2) by maxwell demon on Wednesday January 09 2019, @06:54AM (1 child)
What about enacting the time limit only for three or more posts in a row? Spammers would still get blocked, but most normal users won't run into the restriction.
The logic could be almost the same as currently: Instead of denying a new post when there was one post in the last 60 seconds, you'd deny a new post when there were 2 posts in the last 120 seconds.
The Tao of math: The numbers you can count are not the real numbers.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @11:25AM
Doable but that'd still require formkeys. I was thinking to yoink that logic out entirely for registered users.
My rights don't end where your fear begins.