https://bugzilla.wikimedia.org/show_bug.cgi?id=29287
--- Comment #9 from Ashar Voultoiz <[email protected]> 2011-06-07 13:55:26 UTC --- You still hit a lot of row (640k). Notice the key length is 261! Maybe the index should be created using a shorter length (will have to figure out a correct value). Maybe 24 character long which maps to: '/trunk/phase3/includes/X' '/trunk/extensions/XXXXXX' code_paths (cp_repo_id(24), cp_path) Or 35 characters to includes branches: '/branches/REL1_18/phase3/includes/X' '/branches/REL1_18/extensions/XXXXXX' code_paths (cp_repo_id(35), cp_path) Will have to play a bit with them or use this: echo 'Explain <QUERY HERE>' | sql | domas :) -- 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
