this post was submitted on 03 Sep 2023
75 points (89.5% liked)
Asklemmy
43842 readers
648 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
- [email protected]: a community for finding communities
~Icon~ ~by~ ~@Double_[email protected]~
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
Disclaimer: I am not a Lemmy dev.
It would add some extra rows to a database, which can increase lookup times if enough people do it with enough accounts... so from a general engineering perspective, I wouldn't encourage it.
In a more realistic sense, it would take a lot of people and/or a lot of throwaways to effect much difference. That is, assuming the database queries aren't too complex or inefficient, and the servers aren't nearing critical capacity.
Deleting the account afterwards may not be as effective as never creating the account altogether. There's a chance some stuff is only tombstoned instead of deleted, things get stuck in caches too, it would probably be better than keeping the dormant accounts though.
Tl;dr It would be polite of you to keep only a couple of throwaway accounts, but I wouldn't feel too guilty about making them. Just don't be like a spam bot and create dozens or more.
Depending on implementation, the lookup should be indexed so the time difference would be very minimal on even large tables.
The cutest of storage could be a problem depending on how many wasted accounts exist, but even that should require a ton of accounts to make an impact.
Yeah, there's always room for a lot of implementation-dependent possibilities of good DB practices, but it's also possible for one mistaken PR approval to create exponential load.
In the case of FOSS where there might be fewer formal processes to catch errors, I like to err more heavily on the side of caution. If for no other reason than preventing surprise server scaling bills for the volunteer admins.
Also: if you are making throwaways, please consider donating time and/or cash to those instances.
I like that.