this post was submitted on 25 Jun 2023
22 points (100.0% liked)
Feddit UK
17 readers
1 users here now
Community for the Feddit UK instance.
A place to log issues, and for the admins to communicate with everyone.
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Just taking a cursory look at the code, it appears the ranking of posts per sort is stored in the database routinely via a background process on the server: https://github.com/LemmyNet/lemmy/blob/main/src/scheduled_tasks.rs#L31C10-L31C10
So, could be to do with that. If the server is underprovisioned, maybe it's taking an overly long time to run each calculation and everything is being held up. Complete speculation, though, at this point. 🤷
Edit: this is actually the 1.8 version of the code. Prior to this it looks like this was being done differently (see: https://github.com/LemmyNet/lemmy/pull/2952/files). So like Emperor says, it looks some optimization work was done here as presumably the queries were running too slowly.