Holy crap I just realized why notifications are so slow: I'm querying for all the comments of every item in notifications unnecessarily even though they aren't displayed. So dumb.
I was basically requesting 21 full comment threads every time a user visited their notifications.
edit: Okay, it doesn't appear to be a huge difference in performance but still nice to reduce some server load with a 10 line code fix.
reply
Its always nice to find those little inefficiencies and smooth them out
reply