I noticed my comment votes were disappearing a couple weeks ago. Votes seem to last hours, maybe a day, before they are removed/disappearing. My post votes are unaffected.

In the last few days there was an issue with being able to vote on comments at all. That issue was fixed quickly (thank you), but it doesn’t seem to have fixed the disappearing comment votes issue.

I figured someone would fix the issue soon, but now I’m thinking maybe people don’t know about it.

Galaxy A15, Android 16, Voyager app

  • Rimu@crust.piefed.socialEnglish
    8·
    26 days ago

    How many votes do you think you do per day? Is it about 100?

    edit: I looked at your profile more closely - yes, you DO vote a lot. That would explain it - the cache of recent votes, which the API uses, was too small for your volume. I’ve increased it by 10x, that should do.

    • Vicinus@piefed.zipOPEnglish
      2·
      26 days ago

      Thank you :)

      I wouldn’t have guessed that much, but I’d say that’s reasonable with comments added in.

      • Rimu@crust.piefed.socialEnglish
        3·
        25 days ago

        Yes, the votes table is absolutely massive (10s of GB) so even with perfect indexes, queries & joins on it are slow enough to become a problem if you are doing many things. For example when listing a page of posts in a community when there are 70 posts per page that’d mean lots of interaction with the votes table, that I’d rather avoid.

        Instead, we get the last 3000 votes the viewer cast (a single DB query, or less if it’s in redis already, which is another layer of cache) and hold that in memory. While creating the list of posts a “viewer has voted for this” flag is set if the post id is in the list of votes from earlier. The list of votes is sorted so an efficient binary search can be done.

        That’s just one part of it, there are about 3 or 4 other similar optimizations where front-loading some data drastically reduces the work involved in getting a lot of posts at once. I’ve put days into speeding up the ‘get a list of posts’ API endpoint and it’s become acceptable but still not great.

        The next version of the API is going to be a lot slimmer both in the responses it generates and the CPU work involved in making them. At present we are trying to produce API responses that are very close to what Lemmy provides and that brings a lot of baggage.

        • cloudless@piefed.socialEnglish
          2·
          25 days ago

          Thanks for the detailed explanation. I didn’t expect a simple flag to have such impact, now I know.

          Thanks again for creating PieFed and the continual improvements. That really is a tremendous amount of hard work.