https://bugzilla.wikimedia.org/show_bug.cgi?id=72635

            Bug ID: 72635
           Summary: report table performance, cleanup, and number of items
           Product: Analytics
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Wikimetrics
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected],
                    [email protected], [email protected],
                    [email protected], [email protected],
                    [email protected], [email protected],
                    [email protected]
       Web browser: ---
   Mobile Platform: ---

A Central Auth cohort creates many rows, because with the current
implementation, one MetricReport node is made for each project in a cohort,
which is like 800 projects for most Central Auth cohorts.

This has performance implications if we schedule these reports recurrently.  We
should take the necessary steps to clean up old data, maybe not create so many
records to start with, add indices, etc.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to