Anyone know why? Any way we can promote sh.itjust.works to lighten their load possibly?

  • Slashzero
    link
    fedilink
    English
    8
    edit-2
    2 years ago

    That’s great news! Is there a new release candidate with the DB changes?

    What was it? Missing indexes? Bad query plans? Bad queries in general?

    Glad to see websockets getting ripped out.

    • @[email protected]
      link
      fedilink
      English
      11
      edit-2
      2 years ago

      The hot_rank query was basically hitting the server like a truck. You can read more about it in this github issue, but basically calculating the hot rank in the database has been moved to rust.

      EDIT: For clarity, the database issue was solved a bit ago, but today it was released as a Lemmy version which this server (sh.itjust.works) is now on.

      • Slashzero
        link
        fedilink
        English
        4
        edit-2
        2 years ago

        Excellent! Time to upgrade my instance!

        @[email protected]

        • BE 0.17.4
        • UI 0.17.4

        Upgrade complete! Thanks for the info. BTW, the new UI version no longer shows the UI version in the page footer.