Stats: authors view not reliable when there are hundred of authors

[gibrown]

Impacted plugin

Jetpack

Quick summary

Go to a site such as the a8c FG, go to Stats, and look at the authors module.

It will only intermittently load.

This is likely due to some scaling problem on the backend. There is already some hacky workarounds for VIP sites, which may be related to this. Maybe we need to extend that workaround to other sites. Or maybe the whole implementation needs to be rethought (I implemented the basics of this in 2011 and it was pretty hacky at the time). I wonder if we could pull top posts from Stats as normally, and then just pass the list of post ids to Elasticsearch global index and aggregate on the user names for instance.

Steps to reproduce

Go to a site such as A8C FG and look at the authors module.

Site owner impact

Fewer than 20% of the total website/platform users

Severity

Moderate

What other impact(s) does this issue have?

No response

If a workaround is available, please outline it here.

No response

Platform (Simple and/or Atomic)

No response

[Robertght]

I was able to see it, too, on the FG page.

Marking this as Triaged on our board.