https://bugzilla.wikimedia.org/show_bug.cgi?id=23720
--- Comment #7 from Reedy <s...@reedyboy.net> 2011-01-01 00:49:41 UTC --- r79379, r79381, r79382, r79384... Before: mysql> select count(*) from mw_code_paths WHERE cp_repo_id = 3 AND cp_rev_id > 1 AND cp_rev_id < 1000; +----------+ | count(*) | +----------+ | 2580 | +----------+ 1 row in set (0.02 sec) After: mysql> select count(*) from mw_code_paths WHERE cp_repo_id = 3 AND cp_rev_id > 1 AND cp_rev_id < 1000; +----------+ | count(*) | +----------+ | 6600 | +----------+ 1 row in set (0.00 sec) After the first 1000 done mysql> select count(*) from mw_code_paths WHERE cp_repo_id = 3; +----------+ | count(*) | +----------+ | 516313 | +----------+ 1 row in set (0.26 sec) After the whole repo (78352 locally) mysql> select count(*) from mw_code_paths WHERE cp_repo_id = 3; +----------+ | count(*) | +----------+ | 988825 | +----------+ 1 row in set (1.93 sec) Not really fast, but hardly slow either. Took a few minutes to execute -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
