#1860 closed defect (bug) (fixed)
Add comment_count field to posts table
| Reported by: |
|
Owned by: |
|
|---|---|---|---|
| Milestone: | Priority: | highest omg bbq | |
| Severity: | normal | Version: | 1.6 |
| Component: | General | Keywords: | comments db bg|has-patch |
| Focuses: | Cc: |
Description
Attached is a patch to add a comment_count field to the posts table.
I had to move an action hook in front of the sql that deletes a comment because you can't do anything useful with deleted data!
Hooks included for adding/deleting/editing/changing status of comments.
Attachments (1)
Note: See
TracTickets for help on using
tickets.
Out of curiosity, what is the benefit of keeping a counter of the comments over running the query in revisions prior to this? I would guess that the tradeoff is speed, but don't you potentially lose a bit of reliability?