I'm testing an optimization on lemm.ee (1000x speed-up for subscribed feed) - please let me know if you notice any issues!

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!

34 comments

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 ☺️.

Seems super responsive so far, a night and day difference compared to waiting like 0.5 seconds every refresh on Lemmy World. Thanks!
- Zero issues, really fast work. @sunaurus@lemm.ee, you are an awesome admin. Thank you!

SUPER snappy.
FYI - seeing this post on on ~~federverse~~ fediverse is what brought me here, the lemm.ee project overall and the dev community engagement is encouraging and I hope to have found a home.

Hah you’re not just hosting this excellent instance but optimizing the software too. Thank you! It really is snappy especially in the Memmy app.

It does seem to have a little pep in its step this morning!!! Thanks!

I thought Jerboa had a cached version of the frontpage and had to refresh because of how fast it loaded the first time.
- 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!
- Being on lemm.ee is really causing us some first world problems, amiright? :D

It's very cool to see Lemmy get more and more optimised.

Thank you! Waiting for it to trickle down into the release!

This is the most responsive and reliable instance by far. Thank you.

Will concur that it’s faster to me on voyager which is what I’m using at the moment. Will try some of the other apps and compare. Thank you btw. Great instance here!

Awesome! I think I found my main Lemmy! Finally...

Great initiative, thank you!

You're the man! Much snappy.

Seems very snappy so far on the memmy app.
Thanks for all the work you put into making this a great instance

It does load faster than yesterday, almost instantly i'd say, yesterday I could see the loading icon for a bit, and today it loads in no time.
Awesome work! you have any available way for us to support lemm.ee?
- These links are on the front page of lemm.ee:
  https://github.com/sponsors/sunaurus
  https://ko-fi.com/S6S7M9RT8