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!

top 36 comments

sorted by: hot top controversial new old
[–] 70 points 3 years 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 ☺️.

  • source
  • [–] 47 points 3 years ago (1 child)

    Seems super responsive so far, a night and day difference compared to waiting like 0.5 seconds every refresh on Lemmy World. Thanks!

  • source
  • hideshow 2 child comments
  • [–] 29 points 3 years ago*

    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.

  • source
  • [+] 25 points 3 years ago* (last edited 1 year ago)
    [–] 24 points 3 years 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.

  • source
  • hideshow 4 child comments
  • [–] 17 points 3 years 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!

  • source
  • parent
  • [–] 24 points 3 years ago

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

  • source
  • [–] 20 points 3 years ago

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

  • source
  • [–] 16 points 3 years ago

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

  • source
  • [–] 13 points 3 years ago

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

  • source
  • [–] 13 points 3 years ago

    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!

  • source
  • [–] 12 points 3 years ago* (last edited 3 years ago)

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

  • source
  • [+] 10 points 3 years ago
    [–] 10 points 3 years ago

    Great initiative, thank you!

  • source
  • [–] 9 points 3 years ago

    You're the man! Much snappy.

  • source
  • [–] 8 points 3 years ago*

    Seems very snappy so far on the memmy app.

    Thanks for all the work you put into making this a great instance

  • source
  • [+] 7 points 3 years ago* (last edited 1 year ago) (1 child)
  • [–] 6 points 3 years ago

    seems much faster. nice work!

  • source
  • [–] 6 points 3 years ago

    No issues. Everything loads extremely fast

  • source
  • [–] 6 points 3 years ago*

    Waay faster and zero problems so far

  • source
  • [–] 6 points 3 years ago

    Kinda gave me a heart attack - I was testing some feature for Leomard when suddenly - bam. I can’t send stuff 😅

  • source
  • [–] 6 points 3 years ago

    It’s night and day on Memmy, thanks a lot !

  • source
  • [–] 6 points 3 years ago

    An excellent improvement so far! Gonna keep an eye out for any oddities, but none yet. Major props sunaurus and phiresky!

  • source
  • [–] 5 points 3 years ago

    Works great for me!

  • source
  • [–] 4 points 3 years ago

    Yeah, the feed, especially the subscribed feed, now loads faster with no hiccups.

    A big thank you to you Sir.

  • source
  • [+] 4 points 3 years ago* (last edited 1 year ago)
    [–] 3 points 3 years ago

    Seems like Lemmy on Espresso ☕

  • source
  • [–] 3 points 3 years ago

    Seems good to me.

  • source
  • [–] 3 points 3 years ago

    There is a noticeable difference!!

  • source
  • [–] 3 points 3 years ago

    Working great!

  • source
  • [–] 3 points 3 years ago

    thank you (again) for all the work you put in to make lemmy better!

  • source
  • [–] 1 point 3 years ago (1 child)

    Hei. Palun viska lemm.ee Eesti kogukonda pilk.

  • source
  • hideshow 2 child comments
  • load more comments
    view more: next ›