Issue status update for http://drupal.org/node/1570 Project: Drupal Version: cvs Component: tracker.module Category: feature requests Priority: minor Assigned to: Anonymous Reported by: hafif Updated by: hba Status: won't fix hafif: I just made a patch that creates the block you are look for, check here: http://drupal.org/node/19387. I don't know if killes wants to include it any more now than earlier, though... hba Previous comments: ------------------------------------------------------------------------ April 19, 2003 - 08:27 : hafif but it should be a clever block: it should display the comments title *and* the nodes title, and shouldn't display a node twice.. the GROUP BY query to get this list on a DB with thousands of nodes and comments is very slow. (tracker_page is also very slow) maybe a new table keeping only nid's, cid's and timestamps, would be nice.. ------------------------------------------------------------------------ April 21, 2003 - 20:29 : moshe weitzman I don't understand the 2nd paragraph. How is this different from the display current tracker_page? the idea for a new table is probably a good one. of course, it would be unnecessary if comments were stored as nodes. ------------------------------------------------------------------------ April 28, 2003 - 00:26 : hafif basically what i would like, is something like the "active forum topics" block of the forum.module, also displaying the comments subject. say, most recently node #456 had 3 new comments, node #956 had 2 comments, and node #123 had 1 comment. then the block would display: - subject of comment 3 of #456 title of #456 - subject of comment 2 of #956 title of #956 - subject of comment 1 of #123 title of #123 this way, when you enter the site, you would see say 10 items in that block, and if you recall any of the subjects you click the one above it, then the one above that, and so after a few clicks you catch up completely. the tracker page also displays older comments in the node that has recent activity. it's a good way for catching up if your last visit was a long time ago, but the block i'm suggesting is way faster and more usable for busy sites with frequent visitors. i did this on my installation of drupal which is at http://www.hafif.org/drupalometre using this query instead of the forum.module's block query it's the block right under the logo: SELECT MAX(c.cid) AS ccid, n.nid FROM comments c, node n WHERE c.nid = n.nid AND n.status = 1 GROUP BY n.nid ORDER BY timestamp DESC but it is slow (5 sec), since i have around 45.000 comments, and 15.000 nodes ------------------------------------------------------------------------ October 10, 2004 - 22:45 : killes@www.drop.org A tracker block would be quite expensive in terms of database queries. Blocks can also be generated outside the core, so I won't fix this.