shagie@programming.dev to Programming.dev Meta@programming.dev • 10 months ago-1 New commentsimagemessage-square7 fedilinkarrow-up13file-text
arrow-up13image-1 New commentsshagie@programming.dev to Programming.dev Meta@programming.dev • 10 months agomessage-square7 Commentsfedilinkfile-text
minus-squareUlrikHD@programming.devhexbear2·10 months agocomment_count - old_count after a moderator deleted some comments would be my bet. linkfedilink
minus-squareDie4Ever@programming.devhexbear4·10 months 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 linkfedilink
minus-squareUlrikHD@programming.devhexbear1·edit-210 months 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. linkfedilink
comment_count - old_count
after 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.