[Toolserver-l] Global contrib count

Richard Farmbrough richard at farmbrough.co.uk
Sun Apr 17 16:31:23 UTC 2011


If it's not a time-critical figure, then user:emijrp does something like 
this at 
http://meta.wikimedia.org/wiki/User:Emijrp/List_of_Wikimedians_by_number_of_edits 
.
On 16/04/2011 13:36, Manish Goregaokar wrote:
> Exactly how resource-intensitive would be a bunch of queries that got 
> the editcount from every wiki that you find in toolserver.wiki (821 of 
> them). Basically it'll be a PHP code, which cycles through all the 
> rows in toolserver.wiki, then connects to each server/db in turn (Ill 
> ORDER BY server so I don't have to connect-disconnect every time), and 
> runs
>  SELECT user_editcount,user_registration FROM mw_user WHERE 
> user_name="foo";
>
> Thanks,
> Manish/Earth/ <http://en.wikipedia.org/wiki/User:Manishearth>^*Talk* • 
> Stalk <http://en.wikipedia.org/wiki/Special:Contributions/Manishearth>
>
>
>
> _______________________________________________
> Toolserver-l mailing list (Toolserver-l at lists.wikimedia.org)
> https://lists.wikimedia.org/mailman/listinfo/toolserver-l
> Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20110417/53673333/attachment.htm 


More information about the Toolserver-l mailing list