[14:42:19] ToAruShiroiNeko, yay! [14:55:01] My script is currently calculating the number of active editors in the WikiProject Biography realm. [14:55:08] WikiProject Biography has over 1.75 million articles tagged. [14:57:02] Data data data. [14:57:05] Wikipedia has far too much of it. [15:00:27] _o/ [15:05:25] oi ironholds, is there some index of the most active wikimedia projects somewhere? [15:06:20] 1) enwiki 2) dewiki 3) commonswiki [15:06:21] something like that [15:11:02] 10Quarry: SQL String functions not working - https://phabricator.wikimedia.org/T100057#1317797 (10Aklapper) [16:44:06] harej, define 'most active' ;) [16:44:19] the most active editors? [16:46:31] define 'active editor'? [16:46:44] Active editor *has* a definition. Five or more edits in a rolling 30 day period. [16:46:50] but more seriously, vitalsigns [16:46:56] see, you know our analytics better than I do [18:19:01] Should I look into using multi threading for my scripts if they spend most of their time waiting for SQL queries to be carried out? [18:19:43] harej, probably not. Queries don't run in a vacuum; at a certain point your queries will be running slow because you are simultaneously running many queries [18:19:44] I test my scripts with the time command and I find even if they take 3 hours to run, only like 5 minutes of that is actual computing time. [18:19:56] Good point. [18:20:09] the remaining 2.9 hours are also computing time! Just they're computing time on the other machine :) [23:52:31] hey halfak