142
Where does Lemmy store upvotes, downvotes, and replies?
(lemmy.world)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 15 Oct 2023
142 points (97.3% liked)
Asklemmy
43777 readers
938 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy ๐
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
haven't worked with AP yet, but as a webdev I'm certain it's original server only. Syncing upvotes between nodes would be an insane datavolume and one hell to properly keep in sync to begin with.
They are synced. There is an insane data volume, yes. It is hell.
no way, that's a massive oof o.O
Yeah. A lot of hand-wringing has gone on about it, e.g. https://gist.github.com/jdarcy/60107fe4e653819138396257df302eef. I'll post this and then show you a video of server activity that results.
Demo post
Here is a screencast of what happens to my 2 core server when I post something - https://kglitch.social/activitypub_cpu_and_net.mp4.
I run a single user instance, more or less, so there is little chance of some other user causing this load.
Some of it will be due to the way Kbin is built but I believe any software using ActivityPub to communicate will run into similar issues sooner or later, especially with network traffic usage.
Damn that's crazy. Thanks for the demo
Completly off-topic, but what's that dope af htop replacement?
Looks like btop
btop!
It's very pretty.
What the fuckkk haha this is crazy. Hold on. I'm testing it on my instance now, let's see if Lemmy acts differently
Okay, didn't happen to me at all :(
https://static.lemmy.org.il/activitypub.mp4
Interesting, that's hardly noticeable. Perhaps your instance has less federation relationships happening than mine, or something.