shagie@programming.dev to Programming.dev Meta@programming.devEnglish · 1 year ago-1 New commentsprogramming.devimagemessage-square7fedilinkarrow-up12arrow-down10file-text
arrow-up12arrow-down1image-1 New commentsprogramming.devshagie@programming.dev to Programming.dev Meta@programming.devEnglish · 1 year agomessage-square7fedilinkfile-text
minus-squareUlrikHD@programming.devlinkfedilinkarrow-up1·1 year agocomment_count - old_count after a moderator deleted some comments would be my bet.
minus-squareDie4Ever@programming.devlinkfedilinkarrow-up1·1 year agomore 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
minus-squareUlrikHD@programming.devlinkfedilinkarrow-up1·edit-21 year agoYeah, it’s probably cheaper than than counting the number of comments since a timestamp though. Pure conjecture on my part though, haven’t really done much stuff with SQL.
comment_count - old_countafter a moderator deleted some comments would be my bet.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
Yeah, it’s probably cheaper than than counting the number of comments since a timestamp though. Pure conjecture on my part though, haven’t really done much stuff with SQL.