[drupal-devel] [bug] speed up "Top pages in past n days" page

drumm drupal-devel at drupal.org
Tue Aug 16 18:08:57 UTC 2005

Issue status update for 
Post a follow up: 

 Project:      Drupal
 Version:      cvs
 Component:    statistics.module
 Category:     bug reports
 Priority:     minor
 Assigned to:  Jeremy at kerneltrap.org
 Reported by:  Jeremy at kerneltrap.org
 Updated by:   drumm
 Status:       patch (code needs review)

How about a key on the path column?


Previous comments:

Mon, 15 Aug 2005 17:26:07 +0000 : Jeremy at 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.)

More information about the drupal-devel mailing list