To me, activity means the lastest change, whether it is a new comment or the node author updating the node body. There are more subtile things a node author can do which would change the node timestamp but ordinary users would not perceive as a change, e.g. publish/unpublish from front page or change access permissions. It may be hard to treat these differently and they are rare enough that perhaps they can be treated the same as a textual change. -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of David Strauss Sent: Wednesday, June 06, 2007 1:29 PM To: development@drupal.org Subject: [development] Need consensus on what "activity" means I'm working on a patch that refactors node_comment_statistics into node and performs many other query optimizations. One is that I'm tracking node "activity" as a combined timestamp for the node and the node's comments. Does activity include: 1. The node creation timestamp or the latest comment timestamp 2. #1 plus the node update timestamp Normally, I wouldn't email the dev list about a specific patch, but I need broad feedback because the combined "activity" timestamp will order forum topic and tracker results. The patch: http://drupal.org/node/148849