https://bugzilla.wikimedia.org/show_bug.cgi?id=27112
--- Comment #3 from Ariel T. Glenn <[email protected]> --- the explain doesn't look good, yuck: explain SELECT * FROM `page` INNER JOIN `revision` ON ((page_id=rev_page)) WHERE page_id >= 1157 AND page_id < 1158 ORDER BY page_id ASC, revision.rev_id ASC; +----+-------------+----------+-------+------------------------+---------+---------+---------------------+------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+----------+-------+------------------------+---------+---------+---------------------+------+----------------------------------------------+ | 1 | SIMPLE | page | range | PRIMARY | PRIMARY | 4 | NULL | 1 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | revision | ref | PRIMARY,page_timestamp | PRIMARY | 4 | elwiki.page.page_id | 9 | | +----+-------------+----------+-------+------------------------+---------+---------+---------------------+------+---------------- Prolly need to specify which key or something in here... -- 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
