You are reading a single comment by @hamrack and its replies.
Click here to read the full conversation.
-
Looks well past linear...! The load time fell off a cliff recently, used to be a few seconds (fair enough) but it wasn't noticeable. Now it's painful.
Is there any way to mass unfollow items/a whole sub-forum of items? I would say 95% of that lot are threads from classifieds and it would be a rather laborious task to unfollow them all...
I think I've found the problem.
You're following 26,812 things and it's at 18 seconds.
I'm following 9,857 things and it's at around 3 seconds.
There appears to be some kind of linear degradation in the query, probably a row-level calculation or loop.
It's definitely a bug, I'll have to delve into this later... I'll try to take a look tonight.