Closed GeorgLink closed 5 years ago
solution idea:
New table: new_comments
When a new
[x] comment is made, add/update an entry for each user (new_comments++).
[x] When a user views an issue delete that entry.
[ ] When an issue is closed for 5 days, delete entries for that issue, because no one will want to look at it again. Main o
bjective: clean table regularly.
Pro:
I leave the optimization to delete old entries for later.
solution idea:
New table: new_comments
When a new
[x] comment is made, add/update an entry for each user (new_comments++).
[x] When a user views an issue delete that entry.
[ ] When an issue is closed for 5 days, delete entries for that issue, because no one will want to look at it again. Main o
bjective: clean table regularly.
Pro: