Page MenuHomePhabricator

Improve perf of rolling active editors with dba's suggestions
Closed, DeclinedPublic

Description

ELECT

anon_1.user_id AS anon_1_user_id,
IF(SUM(anon_1.count) >= 5, 1, 0) AS `IF_1`

FROM (
Note "order by null " and archive_userindex

SELECT

  anon_2.user_id AS user_id,
  anon_2.count AS count
FROM (
  ( SELECT 
      revision_userindex.rev_user AS user_id,
      count(revision_userindex.rev_user) AS count
    FROM revision_userindex
    WHERE revision_userindex.rev_timestamp BETWEEN '20140716000000' AND '20140815000000'
    GROUP BY revision_userindex.rev_user
    ORDER BY NULL)
  UNION ALL
  ( SELECT
      archive_userindex.ar_user AS user_id,
      count(archive_userindex.ar_user) AS count
    FROM archive_userindex
    WHERE archive_userindex.ar_timestamp BETWEEN '20140716000000' AND '20140815000000'
    GROUP BY archive_userindex.ar_user
    ORDER BY NULL)
) AS anon_2

) AS anon_1
GROUP BY anon_1.user_id
ORDER BY NULL;


Version: unspecified
Severity: normal

Details

Reference
bz69610

Related Objects

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:34 AM
bzimport set Reference to bz69610.
bzimport added a subscriber: Unknown Object (MLST).
Nuria created this task.Aug 15 2014, 3:32 PM
Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald TranscriptDec 10 2015, 11:01 PM
mforns closed this task as Declined.Mar 26 2019, 2:47 PM
mforns added a subscriber: mforns.

Declining because Wikimetrics is being discontinued. See: T211835.

Restricted Application added a project: Analytics. · View Herald TranscriptMar 26 2019, 2:47 PM