Has anyone else been getting long page load times (like ~10 or more seconds) frequently but intermittently over the last couple days?
Yep, it is the same issue as: https://reddthat.com/post/19658926
There is some Lemmy issue that’s been causing this. I’ve updated to rc-3 just now. So let’s hope that fixes it. (It probably won’t)
Thanks. I’m still seeing some long load times, so it looks like the issue is still present.
Do the RC releases have the federation changes to ditch the sequential transfer model? If so, I wonder if the DB is getting hammered or something…
No it doesn’t (unfortunately). We have a proxy in the EU close to LemmyWorld which batch sends requests to our local queue, which then inserts them into Lemmy. We can sustain over 30/s and our db barely struggles. The DB isn’t the problem as we have a stupid amount of resources at our disposal.
The majority of the time (in my experience with these issues) is that the developers are making changes to how Lemmy works and it inadvertently goes from a query that performed super fast, to a query that is not optimised.
Because we are on the beta tags (for this release only!) we have to weather the storm, but as soon as 0.19.4 is released we’ll go back to only using the production ready releases instead of the beta ones.
I have some time today to do a thorough investigation now so I’ll find the bad query, make an issue, and if it’s a simple fix it will be rolled out within 24/48 hours.
Sometimes on the comments view yes