https://bugzilla.wikimedia.org/show_bug.cgi?id=21995

--- Comment #2 from Bawolff <bawolff...@gmail.com> 2010-01-25 15:03:22 UTC ---
Runing explain on a test mediawiki db that has almost no data in it, i get
(hopefully i got this query right):

mysql> describe SELECT SUM(rfh_total)/SUM(rfh_count) as avg, SUM(rfh_count) as
count, rfh_tag, rfh_page_id from reader_feedback_history where rfh_page_id = 1
and rfh_date > 200 GROUP BY rfh_page_id, rfh_tag\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: reader_feedback_history
         type: ref
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: const
         rows: 6
        Extra: Using where
1 row in set (0.00 sec)


(Not sure if thats useful or not). As far as i can tell, with exception to the
group by clause (in order to make it one query instead of 4), the query is the
same as the one in getAverageRating

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to