this post was submitted on 18 Jul 2023
252 points (100.0% liked)

Meta (lemm.ee)

36 readers
1 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
[–] Odo@lemm.ee 11 points 1 year ago (2 children)

I thought Jerboa had a cached version of the frontpage and had to refresh because of how fast it loaded the first time.

[–] Mythril@lemm.ee 9 points 1 year ago

Haha, that reminds me of some story about a dev who had to add a timer/slowdown to the loading progress bar in some software, because when it worked instantly, the users thought that it did not work at all!

[–] lagomorphlecture@lemm.ee 2 points 1 year ago

Being on lemm.ee is really causing us some first world problems, amiright? :D