athlon

@athlon@lemm.ee

• ⁨Comment⁩ on ⁨Why do comment counts often disagree with what I see?⁩ ⁨⁨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.

• ⁨Comment⁩ on ⁨Why do comment counts often disagree with what I see?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:

  Ok, so basically, there is multiple ways one could comment count. The most obvious option is to count the actual number of comments under the post. This might be in practice slow, as you must load all comments under the post. An alternative approach is to have a count variable for post, which is increased or decreased by 1 if post is added/removed. It’s way faster to retrieve that variable, instead of getting all comments and counting the number of them. The problem starts if some anomaly happens that is not accounted for, so for example, if I request the same comment to be deleted multiple times. So that counter can be decreased more than once for the same comment. This could be fixed pretty easily:

  if comment_to_delete is deleted {
  	// Do not do anything
  	return
  }
  
  post.comment_count -= 1
  delete_comment(comment_to_delete)
  

  And yeah, I thought so too, but ever since I stumbled upon this bug, I think the way the comment count is stored is through the counter variable.

• ⁨Comment⁩ on ⁨Why do comment counts often disagree with what I see?⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:

  I accidentally made a post that has -3 comments.

  This happens because Lemmy does not count the actual number of comments that there are under the post, but instead there is a counter per post. This is not necessarily a bad thing, but it does not seem like the counter is every synced with the actual count of comments.

• ⁨Comment⁩ on ⁨[TECHCRUNCH] Microsoft’s Bing Chat comes to Chrome and Safari in tests for ‘select users’⁩ ⁨⁨1⁩ ⁨year⁩ ago⁩:

  The “test” being whitelisting Chrome/Safari user agent? Because Bing AI works perfectly fine in Safari, as long as you change your user agent to Edge’s.