tracker module should have a block

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