https://bugzilla.wikimedia.org/show_bug.cgi?id=28455
--- Comment #4 from Reedy <[email protected]> 2011-04-10 23:44:02 UTC --- http://192.168.0.190/w/api.php?action=query&list=usercontribs&ucuser=Reedy mysql> EXPLAIN SELECT /* ApiQueryContributions::execute Reedy */ rev_timestamp,page_namespace,page_title,rev_user,rev_user_text,rev_deleted,rev_page,rev_id,page_latest,rev_comment,rev_len,rev_minor_edit,rev_parent_id FROM `mw_page`,`mw_revision` FORCE INDEX (usertext_timestamp) WHERE (page_id=rev_page) AND ((rev_deleted & 4) = 0) AND rev_user_text = 'Reedy' ORDER BY rev_timestamp DESC LIMIT 11; +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ | 1 | SIMPLE | mw_revision | ref | usertext_timestamp | usertext_timestamp | 257 | const | 26 | Using where | | 1 | SIMPLE | mw_page | eq_ref | PRIMARY | PRIMARY | 4 | wikidb.mw_revision.rev_page | 1 | | +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ 2 rows in set (0.00 sec) http://192.168.0.190/w/api.php?action=query&list=usercontribs&ucuser=Reedy&uctoponly mysql> EXPLAIN SELECT /* ApiQueryContributions::execute Reedy */ rev_timestamp,page_namespace,page_title,rev_user,rev_user_text,rev_deleted,rev_page,rev_id,page_latest,rev_comment,rev_len,rev_minor_edit,rev_parent_id FROM `mw_page`,`mw_revision` FORCE INDEX (usertext_timestamp) WHERE (page_id=rev_page) AND ((rev_deleted & 4) = 0) AND rev_user_text = 'Reedy' AND (rev_id = page_latest) ORDER BY rev_timestamp DESC LIMIT 11 -> ; +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ | 1 | SIMPLE | mw_revision | ref | usertext_timestamp | usertext_timestamp | 257 | const | 26 | Using where | | 1 | SIMPLE | mw_page | eq_ref | PRIMARY | PRIMARY | 4 | wikidb.mw_revision.rev_page | 1 | Using where | +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ 2 rows in set (0.00 sec) http://192.168.0.190/w/api.php?action=query&list=usercontribs&ucuser=Reedy&uctoponly&ucdir=newer mysql> EXPLAIN SELECT /* ApiQueryContributions::execute Reedy */ rev_timestamp,page_namespace,page_title,rev_user,rev_user_text,rev_deleted,rev_page,rev_id,page_latest,rev_comment,rev_len,rev_minor_edit,rev_parent_id FROM `mw_page`,`mw_revision` FORCE INDEX (usertext_timestamp) WHERE (page_id=rev_page) AND ((rev_deleted & 4) = 0) AND rev_user_text = 'Reedy' AND (rev_id = page_latest) ORDER BY rev_timestamp LIMIT 11 -> ; +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ | 1 | SIMPLE | mw_revision | ref | usertext_timestamp | usertext_timestamp | 257 | const | 26 | Using where | | 1 | SIMPLE | mw_page | eq_ref | PRIMARY | PRIMARY | 4 | wikidb.mw_revision.rev_page | 1 | Using where | +----+-------------+-------------+--------+--------------------+--------------------+---------+-----------------------------+------+-------------+ 2 rows in set (0.00 sec) On a limited set it's ok... Slow queries are slow -- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
