(mint@ryona.agency)'s status on Sunday, 08-Sep-2024 10:30:41 JST
Okay, apparently what was causing severe performance issues when loading old-ish long threads, and lately even timeline with notifs, was in fact Neetzshe's patch that preloaded scrobbles into the user profile JSON. This could've probably been solved by an index, but considering the fact I'm lazy and the frontend still loads scrobbles by hammering their separate endpoint, I just added a switch to disable returning them in every status. Having sub-second load times on timeline sure feels refreshing. https://gitgud.io/ryonagency/pleroma/-/commit/4507b64267d7d5a767d21c091fe45bd0f42866a1
@BlinkRape That's because of my complicated caching setup to speed things up since I'm hosting an instance in my basement in Russia and proxying it to a VPS in US. Didn't find a workaround to convert those to notice links when requested from a browser yet.
@feld Yeah, I think adding them to user profile is a more sensible approach, it just so happens to cause severe performance issues without some more fiddling.
@mint Send me a link to a patch / commit that adds them to the account view and I'll see what's up, I took a look at this once before but was confused about some PleromaFE stuff so I shelved it
@lauralt No setup, just thought a bit about what thread/timeline/notif pipelines have in common, checked the part that gets the user info, then tried getting scrobbled for a couple of old inactive accounts and came to a realization.
Very nice, excellent! What is a setup that would have caught an issue like this early? Would some post fetching database tests suffice, how about some local end to end tests?