https://bugzilla.wikimedia.org/show_bug.cgi?id=25931
--- Comment #4 from Reedy <[email protected]> 2011-03-22 01:40:24 UTC --- mysql> describe select page_title, page_namespace FROM page JOIN categorylinks ON (page_id=cl_from) AND cl_to="Test" AND page_random >= 0.2265\G +----+-------------+---------------+--------+---------------------------------+--------------+---------+------------------------------+------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+--------+---------------------------------+--------------+---------+------------------------------+------+--------------------------+ | 1 | SIMPLE | categorylinks | ref | cl_from,cl_timestamp,cl_sortkey | cl_timestamp | 257 | const | 3 | Using where; Using index | | 1 | SIMPLE | page | eq_ref | PRIMARY,page_random | PRIMARY | 4 | enwiki.categorylinks.cl_from | 1 | Using where | +----+-------------+---------------+--------+---------------------------------+--------------+---------+------------------------------+------+--------------------------+ 2 rows in set (0.00 sec) That's against enwiki. It doesn't seem '''that''' bad... -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
