Comment on -1 New comments
UlrikHD@programming.dev 1 year ago
comment_count - old_count
after a moderator deleted some comments would be my bet.
Comment on -1 New comments
UlrikHD@programming.dev 1 year ago
comment_count - old_count
after a moderator deleted some comments would be my bet.
Die4Ever@programming.dev 1 year ago
more importantly that means if a comment is deleted and there’s also 1 new comment, then it’ll tell you there’s 0 new comments
UlrikHD@programming.dev 1 year ago
Yeah, it’s probably cheaper than than counting the number of comments since a timestamp though. Pure conjecture though on my part though, haven’t really done much stuff with SQL.