You are reading a single comment by @Velocio and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@Velocio
On "following" performance.
I think it's about as fast as it is going to get.
Where it is slow is entirely down to old notifications as these are never pruned and if you've been following both of the Classifieds forums you could actually have thousands or tens of thousands of notifications.
What I could do is to add a "deleted notifications" thing.
This would only remove your old notifications, not affecting the things you are following... so you'd continue to get new notifications. But it would make the page load in milliseconds.
As an example, @hamrack today the following query takes 1.4 seconds, if I deleted just the notifications for "new items created in a forum you are following", the query would take 198 milliseconds.