Beehaw Support

153 readers

2 users here now

Support and meta community for Beehaw. Ask your questions about the community, technical issues, and other such things here.

A brief FAQ for lurkers and new users can be found here.

Our July 2023 financial update is here.

For a refresher on our philosophy, see also What is Beehaw?, The spirit of the rules, and Beehaw is a Community

This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago

MODERATORS

[email protected]

The Lemmy dev team could use some help with their database issues - Lemmy.world (lemmy.world)

submitted 1 year ago by [email protected] to c/[email protected]

9 comments fedilink hide all child comments

Is there anyone out there with database expertise willing to help?

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 5 points 1 year ago (1 children)

I’m also curious why every page view (to be clear, do you mean every time a post is viewed?) triggers a recalc on the Hot score.

This is the current design, yes. I believe the devs have already started a related issue to change this. I'm assuming the next version of Lemmy will have some major performance improvements.

[–] [email protected] 6 points 1 year ago

Yeah, just thinking about things logically here, the more they can automate expensive queries on the back end on a more periodic basis and then cache the results regardless of what's happening with page views on the front end, the better things should be. It's a lot cheaper for a database to serve cached results in lookups. I'm not a database guy and not really qualified to help fix any of these issues, but I'm just drawing from what I remember from my databases course in college.