--- Comment #2 from Bawolff <> 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:
------- You are receiving this mail because: -------
You are watching all bug changes.

Wikibugs-l mailing list

Reply via email to