No, that will not help.
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.
On Wednesday, October 28, 2015 9:54 PM, Jaime Crespo
<[email protected]> wrote:
https://phabricator.wikimedia.org/P2251
Sorry, no time to do a full profile, even if I would love to, but maybe that is
helpful :-(
On Wed, Oct 28, 2015 at 7:44 PM, Yetkin Sakal <[email protected]> wrote:
user_daily_contribs having been dropped, I am facing serious problems about a
query. How to optimize this?
SELECT
u.user_name,
COUNT(rev.rev_id) AS contribs
FROM
user u
INNER JOIN user_groups ug
ON u.user_id = ug.ug_user
INNER JOIN revision_userindex rev
ON rev.rev_user = u.user_id
WHERE
ug.ug_group IN ('sysop', 'bureaucrat', 'checkuser', 'oversight')
AND rev.rev_timestamp >= 20150928000000
GROUP BY
u.user_name
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l
--
Jaime Crespo
<http://wikimedia.org>
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l
