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!

  • aCosmicWave@lemm.ee
    link
    fedilink
    arrow-up
    36
    arrow-down
    1
    ·
    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 ☺️.

  • simple@lemm.ee
    link
    fedilink
    arrow-up
    10
    ·
    1 year ago

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

  • cowpowered@lemm.ee
    link
    fedilink
    arrow-up
    9
    ·
    1 year ago

    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.

  • JDMaybeMD@lemm.ee
    link
    fedilink
    arrow-up
    7
    ·
    edit-2
    1 year 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.

  • Odo@lemm.ee
    link
    fedilink
    arrow-up
    6
    ·
    1 year ago

    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
      link
      fedilink
      arrow-up
      7
      ·
      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!

  • llama@lemm.ee
    link
    fedilink
    arrow-up
    6
    ·
    1 year ago

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

  • eee@lemm.ee
    link
    fedilink
    arrow-up
    3
    ·
    1 year ago

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