<div dir="ltr">Actually using the date as the first filter rule will improve performance because the IN filter then only has to be applied to a small subset instead of all revisions.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Oct 28, 2015 at 3:28 PM, Yetkin Sakal <span dir="ltr"><<a href="mailto:superyetkin@yahoo.com" target="_blank">superyetkin@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:13px"><div>No, that will not help.</div><div><br></div><div>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><div class="h5"><div><span></span></div>  <br><div><br><br></div><div style="display:block"> <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 <<a href="mailto:jcrespo@wikimedia.org" target="_blank">jcrespo@wikimedia.org</a>> wrote:<br> </font> </div>  <br><br> <div><div><div><div dir="ltr"><div><a rel="nofollow" shape="rect" href="https://phabricator.wikimedia.org/P2251" target="_blank">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><br clear="none"><div>On Wed, Oct 28, 2015 at 7:44 PM, Yetkin Sakal <span dir="ltr"><<a rel="nofollow" shape="rect" href="mailto:superyetkin@yahoo.com" target="_blank">superyetkin@yahoo.com</a>></span> wrote:<br clear="none"><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><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" href="mailto:Labs-l@lists.wikimedia.org" target="_blank">Labs-l@lists.wikimedia.org</a><br clear="none">
<a rel="nofollow" shape="rect" href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">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><div dir="ltr"><div>Jaime Crespo<br clear="none"></div><<a rel="nofollow" shape="rect" href="http://wikimedia.org/" target="_blank">http://wikimedia.org</a>><br clear="none"></div></div>
</div></div></div><br><br></div>  </div> </div>  </div></div></div></div></div><br>_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" rel="noreferrer" target="_blank">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br></div>