<div dir="ltr">*bump*<br><div><div dir="ltr"><span style="font-family:sans-serif;font-size:13px;line-height:19px"><a href="http://en.wikipedia.org/wiki/User:Manishearth" title="User:Manishearth" style="text-decoration:none;color:rgb(6, 69, 173);background-color:initial" target="_blank"><font color="orange">Manish</font><font color="green"><i>Earth</i></font></a><sup style="line-height:1em"><strong><font color="orange">Talk</font></strong> • <a href="http://en.wikipedia.org/wiki/Special:Contributions/Manishearth" title="Special:Contributions/Manishearth" style="text-decoration:none;color:rgb(6, 69, 173);background-color:initial" target="_blank"><font color="green">Stalk</font></a></sup></span><div>
<div><br></div></div>
</div>
<br><br><div class="gmail_quote">On Tue, Apr 19, 2011 at 2:46 PM, Manish Goregaokar <span dir="ltr"><<a href="mailto:manishsmail@gmail.com">manishsmail@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div dir="ltr"><div class="im"><div class="gmail_quote"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>An important key in every allwiki-iteration is imho the re-use of<br>
connections.</div></blockquote></div></div>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.<div><br></div><div>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?</div>
<div><br></div><div><div dir="ltr"><span style="font-family:sans-serif;font-size:13px;line-height:19px"><a href="http://en.wikipedia.org/wiki/User:Manishearth" title="User:Manishearth" style="text-decoration:none;color:rgb(6, 69, 173);background-color:initial" target="_blank"><font color="orange">Manish</font><font color="green"><i>Earth</i></font></a><sup style="line-height:1em"><strong><font color="orange">Talk</font></strong> • <a href="http://en.wikipedia.org/wiki/Special:Contributions/Manishearth" title="Special:Contributions/Manishearth" style="text-decoration:none;color:rgb(6, 69, 173);background-color:initial" target="_blank"><font color="green">Stalk</font></a></sup></span><div>
<div><br></div></div>
</div>
<br></div></div>
</blockquote></div><br></div></div>