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

  • Slashzero@hakbox.social
    link
    fedilink
    English
    arrow-up
    8
    ·
    edit-2
    1 year 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.

    • Barbarian@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      11
      ·
      edit-2
      1 year 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.