See also, http://toolserver.org/~vvv/sulutil.php?user=Manishearth I don't know how that's implemented, but whatever the method is probably isn't causing problems because it's a very widely used tool. (it's linked from the footer of contribs and other interface pages for user/IPs on several major wikis including enwp) -Jeremy

An important key in every allwiki-iteration is imho the re-use of Yeah, I already do that. I've ORDER BY server'd , and I only close and reopen when the server changes. It's quite fast. What's the quick way to get user/page contribution data? I tried using the page table through putty, but it hanged. The revision table works, but I can't get the page title from it. For some reason, the column rev_page is populated with zeroes. I am able to get the username, revid, timestamp, and summary, but I can't fetch the page name/pageid. ANy help? Manish*Earth* <http://en.wikipedia.org/wiki/User:Manishearth>*Talk* • Stalk <http://en.wikipedia.org/wiki/Special:Contributions/Manishearth>

Manish Goregaokar wrote: reopen the can't populated summary, but The quick way to get the user's edit count is to use the stored value from user.user_editcount. If you're trying to use the page table to get edit contribution data, you're going to have trouble, because all edits (contributions) are in the revision table. If you want to use the revision table and fetch page titles, do a join on rev_page = page_id. Then you can select page_namespace and page_title (or the namespace name instead of an integer from the toolserver.namespacename table). More info about accessing and using the replicated databases is available here: <https://wiki.toolserver.org/view/Database_access>. MZMcBride P.S. Plaintext e-mails, please. :-) _______________________________________________ Toolserver-l mailing list (Toolserver-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette