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

  • 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.