https://bugzilla.wikimedia.org/show_bug.cgi?id=24479
--- Comment #21 from Reedy <s...@reedyboy.net> 2011-01-01 02:20:54 UTC ---
Filtered by path and status
mysql> describe SELECT /* IndexPager::reallyDoQuery (SvnRevStatusTablePager)
Reedy */ cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_paths` INNER
JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id = cp_rev_id)) LEFT
JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND cc_rev_id = cp_rev_id))
WHERE cp_repo_id = '3' AND cp_path = '/trunk' AND cr_status = 'new' GROUP BY
cp_rev_id ORDER BY cp_rev_id DESC LIMIT 51;
+----+-------------+-----------------+--------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+----------------------------------------------+
| id | select_type | table | type | possible_keys
| key | key_len | ref
| rows | Extra |
+----+-------------+-----------------+--------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+----------------------------------------------+
| 1 | SIMPLE | mw_code_rev | ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 4 | const
| 45393 | Using where; Using
temporary; Using filesort |
| 1 | SIMPLE | mw_code_paths | eq_ref | PRIMARY
| PRIMARY | 265 | const,wikidb.mw_code_rev.cr_id,const
| 1 | Using where; Using index |
| 1 | SIMPLE | mw_code_comment | ref | cc_repo_id,cc_repo_time
| cc_repo_id | 8 |
wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index
|
+----+-------------+-----------------+--------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+----------------------------------------------+
3 rows in set (0.00 sec)
Filtered by path
mysql> describe SELECT /* IndexPager::reallyDoQuery (SvnRevTablePager) Reedy */
cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_paths` INNER
JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id = cp_rev_id)) LEFT
JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND cc_rev_id = cp_rev_id))
WHERE cp_repo_id = '3' AND cp_path = '/trunk' GROUP BY cp_rev_id ORDER BY
cp_rev_id DESC LIMIT 51;
+----+-------------+-----------------+--------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+---------------------------------+
| id | select_type | table | type | possible_keys
| key | key_len | ref
| rows | Extra |
+----+-------------+-----------------+--------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+---------------------------------+
| 1 | SIMPLE | mw_code_rev | ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 4 | const
| 45393 | Using temporary; Using
filesort |
| 1 | SIMPLE | mw_code_paths | eq_ref | PRIMARY
| PRIMARY | 265 | const,wikidb.mw_code_rev.cr_id,const
| 1 | Using where; Using index |
| 1 | SIMPLE | mw_code_comment | ref | cc_repo_id,cc_repo_time
| cc_repo_id | 8 |
wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index
|
+----+-------------+-----------------+--------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+---------------------------------+
3 rows in set (0.00 sec)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
