https://bugzilla.wikimedia.org/show_bug.cgi?id=63777
--- Comment #9 from Cyberpower678 <cybernet...@yahoo.com> --- (In reply to Sean Pringle from comment #7) > A user_timestamp index has been added the archive base tables on > labdb100[123] for all wikis. Thanks for the fix, but I think revision might still have some performance issues. [time] => 153.57 [query] => SELECT rev_timestamp, page_title, page_namespace FROM revision_userindex JOIN page ON page_id = rev_page WHERE `rev_user` ='82835' AND `rev_timestamp` > 1 ORDER BY rev_timestamp ASC LIMIT 0,2698492; [result] => succeeded was returned by my tool in a debug report. -- 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