- 2 Posts
- 20 Comments
Rimu@crust.piefed.socialto
PieFed Meta@piefed.social•Issue: Comment Votes Disappear (Daily?)English
3·2 months agoYes, the votes table is absolutely massive (10s of GB) so even with perfect indexes, queries & joins on it are slow enough to become a problem if you are doing many things. For example when listing a page of posts in a community when there are 70 posts per page that’d mean lots of interaction with the votes table, that I’d rather avoid.
Instead, we get the last 3000 votes the viewer cast (a single DB query, or less if it’s in redis already, which is another layer of cache) and hold that in memory. While creating the list of posts a “viewer has voted for this” flag is set if the post id is in the list of votes from earlier. The list of votes is sorted so an efficient binary search can be done.
That’s just one part of it, there are about 3 or 4 other similar optimizations where front-loading some data drastically reduces the work involved in getting a lot of posts at once. I’ve put days into speeding up the ‘get a list of posts’ API endpoint and it’s become acceptable but still not great.
The next version of the API is going to be a lot slimmer both in the responses it generates and the CPU work involved in making them. At present we are trying to produce API responses that are very close to what Lemmy provides and that brings a lot of baggage.
Rimu@crust.piefed.socialto
PieFed Meta@piefed.social•Issue: Comment Votes Disappear (Daily?)English
8·2 months agoHow many votes do you think you do per day? Is it about 100?
edit: I looked at your profile more closely - yes, you DO vote a lot. That would explain it - the cache of recent votes, which the API uses, was too small for your volume. I’ve increased it by 10x, that should do.
Rimu@crust.piefed.socialto
Climate@slrpnk.net•What would the communist solution to climate change look like?English7·2 months agoChernobyl did get solved tho, at great personal sacrifice by some very brave people.
Rimu@crust.piefed.socialto
PieFed Meta@piefed.social•Tag Cloud UI is difficult to use.English
1·2 months agoOr tabs, ‘Cloud’ and ‘List’, similar to how user profiles have ‘Overview’, ‘Posts’ and ‘Comments’?
Rimu@crust.piefed.socialto
Reddit@lemmy.world•Reddit is controlled by Bots - protect your opinionsEnglish
14·2 months agoThat’s ironic, because this post was written by a LLM. The edits are human but the bulk of the initial post is LLM text.
Lemmy fixes this in v1.0.
Rimu@crust.piefed.socialto
Fediverse@lemmy.world•The Fediverse and Content Creation: MonetizationEnglish
8·2 months agoLike what peertube has?
Rimu@crust.piefed.socialto
PieFed Meta@piefed.social•Umm... boss? Sir Rimu? Is there a reason why the PF logo now reminds me of the flag of Iraq?English
5·3 months agoIt’ll be back to normal soon :)
Rimu@crust.piefed.socialto
PieFed Meta@piefed.social•PieFed Logo Not Working Today?English
0·3 months agoFinally, @jerry@feddit.online it happened to me too! The mysterious disappearing logo!
Rimu@crust.piefed.socialto
Technology@lemmy.zip•'Big Short' Michael Burry bets $1bn on AI bubble bursting | LBCEnglish
36·3 months agoWell, kinda. To be more specific, he’s mostly betting that Palantir is overvalued, which it probably is. Peter Thiel is a nut case.
Rimu@crust.piefed.socialto
Not The Onion@lemmy.world•Top White House official selling Arlington home after activists write chalk messages on sidewalk | ARLnow.comEnglish
13·4 months agoI think they were planning to sell anyway and the chalking happened during the selling process so they thought they could drum up some outrage from it.
Rimu@crust.piefed.socialto
Programming@programming.dev•JetBrains to opt-in all non-commercial IDE users to training AI modelsEnglish
11·4 months agoI’m still running v2023.1 because that’s the last version before they stuffed so much AI into it that my CPU screams constantly while running it. The writing is on the wall with those guys.
Rimu@crust.piefed.socialto
Casual Conversation@piefed.social•Weekly thread - How is your week going?English
1·4 months agoCrushing it!
Rimu@crust.piefed.socialto
Technology@lemmy.world•Dem Orders Congressional Probe Into Epstein and Peter Thiel’s RelationshipEnglish
5·5 months agoThere’s a mental image I could do without.
Rimu@crust.piefed.socialto
Fediverse@lemmy.world•Statement on discourse about ActivityPub and AT Protocol by W3C SocialCGEnglish
2·5 months agoIt was pretty bizarre how it was published in such a way that it seemed to come from w3c socialcg when really it was just Emelia.
Despite being an activitypub dev I have not seen any of the supposed “heated discussions” probably because I don’t spend time on Mastodon trying to boost ATProto. It doesn’t seem like a widespread problem to me.
Rimu@crust.piefed.socialto
Technology@lemmy.world•Study: Social media probably can’t be fixedEnglish
1·6 months agoVeerry interesting, yes…
Rimu@crust.piefed.socialto
unixporn@lemmy.world•[i3] Stretching 2 Gigs of RAM as far as they will possibly go.English
3·6 months agoConsider using Zram to compress half your ram. That will make your 2 GB into 3 GB, kinda. Do not compress all of it, performance will suffer greatly.
Also, web browser choice is going to be crucial when it comes time to actually use the computer for anything. Try Konqueror, Falkon, Palemoon etc.
Rimu@crust.piefed.socialto
PieFed Meta@piefed.social•Mobile Hamburger Menu SuggestionEnglish
4·6 months agoYes, I agree. Will sort it out.
Rimu@crust.piefed.socialto
Global News@lemmy.zip•US | Epstein scandal broadens as trove of letters from famous figures publishedEnglish
29·6 months agoSteve Bannon, lol



It tells you if the post / comment was written by a LLM.
Please use sparingly, it puts a lot of load on the server.