this post was submitted on 18 Jul 2023
470 points (99.4% liked)

Meta (lemm.ee)

3579 readers
2 users here now

lemm.ee Meta

This is a community for discussion about this particular Lemmy instance.

News and updates about lemm.ee will be posted here, so if that's something that interests you, make sure to subscribe!


Rules:


If you're a Discord user, you can also join our Discord server: https://discord.gg/XM9nZwUn9K

Discord is only a back-up channel, !meta@lemm.ee will always be the main place for lemm.ee communications.


If you need help with anything, please post in !support instead.

founded 1 year ago
MODERATORS
 

Hey folks!

I have deployed an unreleased Lemmy optimization on lemm.ee which significantly speeds up the query for loading posts.

So far, all seems good, but if you notice any issues with any of the post feeds, please let me know!


For more context:

Over the past few days, I have noticed a serious degradation for front page load times for some users. I have been trying different optimizations without much success, until I found an idea by @phiresky@lemmy.world to make a relatively small change to the database query for loading posts.

I implemented this idea and made a PR to Lemmy, you can check my PR here: https://github.com/LemmyNet/lemmy/pull/3653. Initial results seem amazing, my personal subscribed feed now loads extremely quickly, and I'm seeing from monitoring that load times should be improved for other lemm.ee users as well!

you are viewing a single comment's thread
view the rest of the comments
[–] aCosmicWave@lemm.ee 70 points 1 year ago

I only observed a disappointing 995x improvement. What can I do to attain the remaining 5x?

Just kidding - you rock! I originally signed on with lemm.ee after I read one of your previous optimization posts regarding Cloudflare. You seemed like a gent who was on top of his game ☺️.