Issue status update for http://drupal.org/node/28924 Post a follow up: http://drupal.org/project/comments/add/28924 Project: Drupal Version: cvs Component: statistics.module Category: bug reports Priority: minor Assigned to: Jeremy@kerneltrap.org Reported by: Jeremy@kerneltrap.org Updated by: drumm Status: patch (code needs review) How about a key on the path column? drumm Previous comments: ------------------------------------------------------------------------ Mon, 15 Aug 2005 17:26:07 +0000 : Jeremy@kerneltrap.org Attachment: http://drupal.org/files/issues/statistics.module-cvs_0.patch (615 bytes) Displaying statistics pages can be slow. The attached patch removes one of the "GROUP BY" columns to increase the speed of generating the "Top pages in the past n days" page. (Grouping by 'title' does not work, as there are many different paths that can have the same title. Instead, 'path' is unique for each page, so it is a more logical column to group by. I tested this on my active webpage to verify that the resulting page was what I expected.)