<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_1_1446029919199_48896">No, that will not help.</div><div id="yui_3_16_0_1_1446029919199_48804"><br></div><div id="yui_3_16_0_1_1446029919199_48805">Do you know any tools that use the revision view and execute efficient queries on it? I am not sure what I am missing here.<br></div><div id="yui_3_16_0_1_1446029919199_48802"><span></span></div> <br><div class="qtdSeparateBR"><br><br></div><div style="display: block;" class="yahoo_quoted"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font face="Arial" size="2"> On Wednesday, October 28, 2015 9:54 PM, Jaime Crespo <jcrespo@wikimedia.org> wrote:<br> </font> </div> <br><br> <div class="y_msg_container"><div id="yiv1288027078"><div><div dir="ltr"><div><a rel="nofollow" shape="rect" target="_blank" href="https://phabricator.wikimedia.org/P2251">https://phabricator.wikimedia.org/P2251</a><br clear="none"><br clear="none"></div>Sorry, no time to do a full profile, even if I would love to, but maybe that is helpful :-(<br clear="none"></div><div class="yiv1288027078gmail_extra"><br clear="none"><div class="yiv1288027078gmail_quote">On Wed, Oct 28, 2015 at 7:44 PM, Yetkin Sakal <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:superyetkin@yahoo.com" target="_blank" href="mailto:superyetkin@yahoo.com">superyetkin@yahoo.com</a>></span> wrote:<br clear="none"><blockquote class="yiv1288027078gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="yiv1288027078yqt2699137510" id="yiv1288027078yqt74855"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div dir="ltr">user_daily_contribs having been dropped, I am facing serious problems about a query. How to optimize this?</div><div dir="ltr"><br clear="none"></div><div dir="ltr">SELECT<br clear="none"> u.user_name,<br clear="none"> COUNT(rev.rev_id) AS contribs<br clear="none">FROM<br clear="none"> user u<br clear="none"> INNER JOIN user_groups ug<br clear="none"> ON u.user_id = ug.ug_user<br clear="none"> INNER JOIN revision_userindex rev<br clear="none"> ON rev.rev_user = u.user_id<br clear="none">WHERE<br clear="none"> ug.ug_group IN ('sysop', 'bureaucrat', 'checkuser', 'oversight')<br clear="none"> AND rev.rev_timestamp >= 20150928000000<br clear="none">GROUP BY<br clear="none"> u.user_name<br clear="none"><br clear="none"></div></div></div></div><br clear="none">_______________________________________________<br clear="none">
Labs-l mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:Labs-l@lists.wikimedia.org" target="_blank" href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://lists.wikimedia.org/mailman/listinfo/labs-l">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br clear="none">
<br clear="none"></blockquote></div><br clear="none"><br clear="all"><br clear="none">-- <br clear="none"><div class="yiv1288027078gmail_signature"><div dir="ltr"><div>Jaime Crespo<br clear="none"></div><<a rel="nofollow" shape="rect" target="_blank" href="http://wikimedia.org/">http://wikimedia.org</a>><br clear="none"></div></div>
</div></div></div><br><br></div> </div> </div> </div></div></body></html>