The hot_rank query was basically hitting the server like a truck. You can read more about it in this github issue, but basically calculating the hot rank in the database has been moved to rust.
EDIT: For clarity, the database issue was solved a bit ago, but today it was released as a Lemmy version which this server (sh.itjust.works) is now on.
That’s great news! Is there a new release candidate with the DB changes?
What was it? Missing indexes? Bad query plans? Bad queries in general?
Glad to see websockets getting ripped out.
The hot_rank query was basically hitting the server like a truck. You can read more about it in this github issue, but basically calculating the hot rank in the database has been moved to rust.
EDIT: For clarity, the database issue was solved a bit ago, but today it was released as a Lemmy version which this server (sh.itjust.works) is now on.
Excellent! Time to upgrade my instance!
@Barbarian@sh.itjust.works
Upgrade complete! Thanks for the info. BTW, the new UI version no longer shows the UI version in the page footer.