this post was submitted on 14 Jun 2023
30 points (94.1% liked)
Asklemmy
43792 readers
928 users here now
A loosely moderated place to ask open-ended questions
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- !lemmy411@lemmy.ca: a community for finding communities
~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Lemmy development really needs another couple weeks or a month. There are over 100 instances peering and it's really pushing the database systems hard with the 100,000 users already. Database tuning and query optimization in the code is the order of the day. I also think some of the new front-end apps for web and smartphones would help.
I'm genuinely asking and don't mean this the way it sounds, but is this supposition or have you observed this yourself?
Everyone says their own instances aren't very resource intensive. Even the larger instances like lemmy.world don't seem to have huge specs.
Although there's a lot of subscriptions there doesn't seem to be an overwhelming amount of content being produced. The most active threads in /home have like 150 comments over 2 days? I don't have the data and this really is mere supposition but it just doesn't seem like that much load.
I did see they pushed a new version with some db optimisations so that's probably an indicator that you're right. Also things just feel unstable. Unusually long page load times or 500 errors just occasionally. Things definitely aren't great I'm just not certain that db linkages are the problem.
Yes, and I've been building social media message systems since 1984, and I'm a published author on messaging systems. I described some of the data integrity and sever malfunctions on multiple systems that have small to large numbers of users, including my own system on Oracle Cloud that has only me as a developer/user. Example of how it is failing: https://lemmy.ml/comment/616698