Where is this screenshot from? Link me plz :)

I said that in a support post on lemmy.world, and got accused of pushing an agenda 🙃

The major issue I see with Lemmy communities and Kbin magazines, is that they both rely on a single server to be up and running to even work. Sure, you can cross-post to several communities at once, but that generates one different thread per community. Add to that the fact that to even start to implement a single distributed thread properly cross-posted to several communities, they must take into account that a given user or server may be defederated from one community but not another - should the user not receive the message if at least one server bans the user, or should the user be allowed to receive it if at least one server allows the user to receive it?

Lemmy's machine-generated ORM SQL and hand-made flawed PostgreSQL TRIGGER logic is so bad, bloated. The developers on GitHub brag about "high performance". It's unbeliable.

In reality, small instances work because it has so many SQL performance problems that it mostly only is stable with little posts and comments in the database. They dd everything they could to avoid using Lemmy itself to discuss !lemmyperformance@lemmy.ml topics and hang out on Matrix Chat to avoid using the constantly-crashing servers they created.

If you go to a server with no users creating comments and posts and only has a tiny amount of data, it does crash a lot less.