https://bugzilla.wikimedia.org/show_bug.cgi?id=17215
Roan Kattouw <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Roan Kattouw <[email protected]> 2009-01-29 16:36:58 UTC --- (In reply to comment #2) > What's the query that would be run? > SELECT /* ApiQueryContributions::execute Catrope */ rev_timestamp,page_namespace,page_title,rev_user_text,rc_patrolled FROM `page`,`revision` FORCE INDEX (usertext_timestamp) LEFT JOIN `recentchanges` ON ((rc_this_oldid=rev_id)) WHERE (page_id=rev_page) AND rev_deleted = '0' AND rev_user_text = 'Gurch' ORDER BY rev_user_text DESC, rev_timestamp DESC LIMIT 11 I personally don't see how this produces huge joins, as we're joining on unique indices, but then I've been known to be completely wrong about DB-related stuff before :D -- 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
