this post was submitted on 06 Jun 2023
36 points (100.0% liked)

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
 

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] 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.