https://bugzilla.wikimedia.org/show_bug.cgi?id=48873
--- Comment #5 from Marcin Cieślak <[email protected]> --- Does adding some time limit help a bit? Here is the actual query if using "get edits": SELECT cuc_namespace, cuc_title, cuc_user, cuc_user_text, cuc_comment, cuc_actiontext, cuc_timestamp, cuc_minor, cuc_page_id, cuc_type, cuc_this_oldid, cuc_last_oldid, cuc_ip, cuc_xff,cuc_agent FROM `cu_changes` FORCE INDEX (cuc_ip_hex_time) WHERE (cuc_ip_hex = '0A40007F') AND (1 = 1) ORDER BY cuc_timestamp DESC LIMIT 5001 when doing "get users": SELECT cuc_user_text, cuc_timestamp, cuc_user, cuc_ip, cuc_agent, cuc_xff FROM `cu_changes` FORCE INDEX (cuc_ip_hex_time) WHERE (cuc_ip_hex = '0A40007F') AND (1 = 1) ORDER BY cuc_timestamp DESC LIMIT 10000 can you post EXPLAIN of those queries? -- 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
