We are joining on the ga_stats table to order nodes by number of views. This works fine however the view count is not indexed, if it was this would speed up the query.

CommentFileSizeAuthor
#1 ga_stats-index_count-1687928-1.patch1.04 KBdwkitchen
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

dwkitchen’s picture

dwkitchen CreditAttribution: dwkitchen commented
FileSize
ga_stats-index_count-1687928-1.patch1.04 KB

Patch for the above attached

dwkitchen’s picture

dwkitchen CreditAttribution: dwkitchen commented
Status: Active » Needs review
jec006’s picture

jec006 CreditAttribution: jec006 commented

Thanks, committed here: http://drupalcode.org/project/ga_stats.git/commit/a55b3b0

jec006’s picture

jec006 CreditAttribution: jec006 commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.