Interesting! Didn’t know about that, good to know!

Every instance is like this it seems, maybe lemmy doesn’t make a batched select at the cache and the db, but idk.

Maybe a new webscale backend could solve this, but i’m just a java backend developer, not a rust one. Maybe could be an interesting project, scala + pulsar + batching, turning lemmy into a microservices hellscape.

Edit: but