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

  • Tiff@reddthat.comMEnglish
    4·
    6 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.comMEnglish
        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.comEnglish
          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.

      • Tiff@reddthat.comMEnglish
        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.comOPEnglish
          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.comMEnglish
            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