this post was submitted on 21 Jan 2024
59 points (83.9% liked)
Announcements
242 readers
10 users here now
Community updates and announcements.
Admins will post any updates here so be sure to follow!
Important updates will be pinned to the local feed.
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
It would be interesting to see benchmarks for different mock scenarios (regular user interaction, federation etc...). My understanding is that Lemmy has had a poor database design and bad SQL queries for a very long time, not sure if that improved (but since response times are definitely low with recent versions I guess yes), but it would be really cool if the database could be designed for performance from the bottom up instead of having it as an afterthought which led to the huge downtimes that we experienced last summer when servers with AMD EPYC CPUs and 100s of GBs of RAM couldn't handle a few ten thousand users.
Our goal is to fix the database. I've reengineered it. This has caused us to need a migration path rather than drop-in replacement. I didn't want to inherit their schema.
That's pretty cool, best luck with the project!
Thanks!
Good point