| Bug : | Comment count info stored in the page table |
| Status : | Fixed |
| Severity : | Enhancement |
| Reporter : | tefra  02-04-2008 13:13 |
| Updated by : | Olivier C. 26-05-2008 23:18 |
| Category | Pages |
| Version : | 121 |
| Frequency : | Consistently |
| Fixed in : | 125 |
| Details : | Although there is the page_rating field in the pages table it's not used. In list.php during page listing there are extra queries to show ratings and comment counts. We can easily get rid of these queries by saving in the page table the comments count, the rate counts (1+9+8+10+5+2)and the number of votes. |
| Items affected : | system/core/list/list.inc.php, system/functions.php |
History and comments :
| 26-05-2008 23:19 Olivier C. New column page_comcount for the comments, the ratings will stay as-is, it's a simple JOIN between 2 tables, not a whole count. |
| 26-05-2008 23:18 Olivier C. PM sent to the reporter : |
| 21-05-2008 09:53 Olivier C. PM sent to the reporter : |