Has anyone else been getting long page load times (like ~10 or more seconds) frequently but intermittently over the last couple days?

    • e0qdk@reddthat.comOP
      link
      fedilink
      English
      arrow-up
      3
      ·
      5 months ago

      Thanks. I’m still seeing some long load times, so it looks like the issue is still present.

      Do the RC releases have the federation changes to ditch the sequential transfer model? If so, I wonder if the DB is getting hammered or something…

      • Tiff@reddthat.comM
        link
        fedilink
        English
        arrow-up
        4
        ·
        5 months ago

        No it doesn’t (unfortunately). We have a proxy in the EU close to LemmyWorld which batch sends requests to our local queue, which then inserts them into Lemmy. We can sustain over 30/s and our db barely struggles. The DB isn’t the problem as we have a stupid amount of resources at our disposal.
        The majority of the time (in my experience with these issues) is that the developers are making changes to how Lemmy works and it inadvertently goes from a query that performed super fast, to a query that is not optimised.

        Because we are on the beta tags (for this release only!) we have to weather the storm, but as soon as 0.19.4 is released we’ll go back to only using the production ready releases instead of the beta ones.

        I have some time today to do a thorough investigation now so I’ll find the bad query, make an issue, and if it’s a simple fix it will be rolled out within 24/48 hours.

          • Tiff@reddthat.comM
            link
            fedilink
            English
            arrow-up
            3
            ·
            5 months ago

            Are you still getting the long load times? We have updated multiple times since then and I haven’t found anything obvious which would be causing issues. Cheers

            • e0qdk@reddthat.comOP
              link
              fedilink
              English
              arrow-up
              2
              ·
              5 months ago

              I was getting it a few days ago, but I’m pretty sure you weren’t on 0.19.4-rc.11 yet the last time I saw it. Testing for a few minutes just now I haven’t managed to reproduce it. Will let you know if I see the issue again. (Hopefully it’s just good now!) Thanks!

              I did find a small issue while checking though – on mlmym’s settings page, the logo in the top left is showing up with src %3cnil%3e instead of a valid path.

              • Tiff@reddthat.comM
                link
                fedilink
                English
                arrow-up
                2
                ·
                5 months ago

                Yep the underlying bug was finally fixed in -rc.11.

                Basically our logo died every time the container restarted as it was never properly saved.

                I’ll fix our logo backup soon

          • Tiff@reddthat.comM
            link
            fedilink
            English
            arrow-up
            2
            ·
            5 months ago

            Are you still getting the long load times? We have updated multiple times since then and I haven’t found anything obvious which would be causing issues. Cheers

            • ValenThyme@reddthat.com
              link
              fedilink
              English
              arrow-up
              2
              ·
              5 months ago

              I have never really had any load time problems I was more thanking you for the general effort of dealing with the server for us. I have tried a few and this is definitely the best of 'em.