Comment on Why do comment counts often disagree with what I see?

• density@kbin.social ⁨1⁩ ⁨year⁩ ago

  because when you load any page listing posts, you don't want your server to have to go and download the actual entire comment thread for every post that is listed. And then have to go and count how many there are.

  Because it would be slow, especially with multiple servers involved. Every time you loaded your home page or a community the server would have to start from scratch gathering the data. It would be more accurate but it would be very hard. And not give a lot of extra value.

  So it's more efficient to have a piece of data attached to the post that just reports the number of comments. Same way as there is a piece of data that contains the title, the name of the person who posted it etc. And that value is updated in some way. Apparently in a way that has not yet been perfected. :)

  source

  • PeleSpirit@lemmy.world ⁨1⁩ ⁨year⁩ ago

    I appreciate your patience, I updated my previous comment, I think I finally get what you’re saying.

    source
• athlon@lemm.ee ⁨1⁩ ⁨year⁩ ago

  Getting the total number of all comments may be very resource heavy if there is a lot of comments.

  If it’s just 5 comments, then the computer can quickly get them all from database and count how many of them are there. Now imagine if there is 50 000 comments and suddenly, you me and entire website ask “how many comments are there for this post?”

  Suddenly the computer is overwhelmed by the request and you may end up crashing it due to amount of tasks it has to do.

  It’s way faster if instead of all of that, the computer kept track of a number of all comments and simply adjust it when comment is added or removed. It does not have to get all the comments and count how many are there, just simply return the number and you are done.

  But in the essence, you sacriface potential accuracy for speed. You may accidentally “desynchronize” the counter - if an user requests a removal of the same comment twice, and you don’t check if that comment was not removed. Or, in theory, if two separate users add or remove a comment at the same time. This is called “race condition”, which is common in multi-threaded computing.

  source

  • PeleSpirit@lemmy.world ⁨1⁩ ⁨year⁩ ago

    Okay, is it because I haven’t had my coffee yet?

    First line:

    Getting the total number of all comments may be very resource heavy if there is a lot of comments.

    Fourth paragraph:

    It’s way faster if instead of all of that, the computer kept track of a number of all comments and simply adjust it when comment is added or removed. It does not have to get all the comments and count how many are there, just simply return the number and you are done.

    What is the difference between the bolded parts?

    source