Having a rough start to the day. My neighbor is an airbnb host of a house that sleeps 15. It's basically a party venue rental business in a residential neighborhood. They are kind of simpleminded so don't seem to grasp the game theory of the situation - their guests have no reason to have compassion for the neighbors and the host themselves have weak incentive to make them compassionate.
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.
reply
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