<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">It was indexed by both in the past. And it should be that way too. Looking up by username is an unreliable way of counting edits.<div class=""><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Cyberpower678<br class="">English Wikipedia Account Creation Team<br class="">Mailing List Moderator</div><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""></div><br class="Apple-interchange-newline">
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On Nov 9, 2014, at 14:00, John <<a href="mailto:phoenixoverride@gmail.com" class="">phoenixoverride@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">revision user index is indexed on user name not user ID<br class=""></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Sun, Nov 9, 2014 at 1:25 PM, Maximilian Doerr <span dir="ltr" class=""><<a href="mailto:maximilian.doerr@gmail.com" target="_blank" class="">maximilian.doerr@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">Every tool I use seems to be slow. It seems we have some broken indexes on the databases.<div class=""><br class=""></div><div class="">Here is an execution report from my super count tool when it looked me up. Time is logged in seconds.</div><div class=""><br class=""></div><div class=""><pre style="padding:9.5px;font-family:Monaco,Menlo,Consolas,'Courier New',monospace;font-size:13px;color:rgb(51,51,51);border-top-left-radius:4px;border-top-right-radius:4px;border-bottom-right-radius:4px;border-bottom-left-radius:4px;margin-top:0px;margin-bottom:10px;line-height:20px;word-break:break-all;word-wrap:break-word;white-space:pre-wrap;background-color:rgb(245,245,245);border:1px solid rgba(0,0,0,0.14902)" class=""> [executiontime] => Array
(
[basic_stats] => Array
(
[queries] => Array
(
[0] => Array
(
[time] => 0.77
[query] => SELECT COUNT(*) AS count FROM archive_userindex WHERE (`ar_user` ='14836860');
[result] => succeeded
)
[1] => Array
(
[time] => 18.95
[query] => SELECT rev_timestamp, page_title, page_namespace FROM revision_userindex JOIN page ON page_id = rev_page WHERE (`rev_user` = '14836860') AND `rev_timestamp` > 1 ORDER BY rev_timestamp ASC LIMIT 0,2688354;
[result] => succeeded
)
)
[total] => 19.89
)
[replag] => Array
(
[total] => 0
[queries] => Array
(
[0] => Array
(
[time] => 0
[query] => SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(rc_timestamp) as replag FROM recentchanges_userindex ORDER BY rc_timestamp DESC LIMIT 1;
[result] => succeeded
)
)
)
[usergroups] => Array
(
[total] => 0.06
[queries] => Array
(
[0] => Array
(
[query] => <a href="http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Cyberpower678&usprop=groups&format=php" target="_blank" class="">http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Cyberpower678&usprop=groups&format=php</a>
[time] => 0.06
[result] => succeeded
)
)
)
[namespaces] => Array
(
[total] => 0.1
[queries] => Array
(
[0] => Array
(
[query] => <a href="http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces&format=php" target="_blank" class="">http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces&format=php</a>
[time] => 0.1
[result] => succeeded
)
)
)
)
</pre><div class=""><br class=""></div><div class="">
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; word-wrap: break-word;" class="">Cyberpower678<br class="">English Wikipedia Account Creation Team<br class="">Mailing List Moderator</div><div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; word-wrap: break-word;" class=""><br class=""></div><br class="">
</div>
<br class=""></div></div><br class="">_______________________________________________<br class="">
Labs-l mailing list<br class="">
<a href="mailto:Labs-l@lists.wikimedia.org" class="">Labs-l@lists.wikimedia.org</a><br class="">
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank" class="">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br class="">
<br class=""></blockquote></div><br class=""></div>
_______________________________________________<br class="">Labs-l mailing list<br class=""><a href="mailto:Labs-l@lists.wikimedia.org" class="">Labs-l@lists.wikimedia.org</a><br class="">https://lists.wikimedia.org/mailman/listinfo/labs-l<br class=""></div></blockquote></div><br class=""></div></body></html>