Improve loading fandoms on user and pseud dashboards (to orphan_account's scale)

Description

The hotly-anticipated sequel of AO3-5694. Now that we've confirmed the current way of aggregating fandoms on user dashboards does not scale, we need an alternative.

We will probably end up using Elasticsearch aggregations (in which case we need to remove the default limit of 10 on the number of facets; related: ).

How to test:

  • The orphan_account user's dashboard should load and display its fandoms.

  • Make sure only tags applied directly to the works are included in the list. For example, this means if you post a work and tag it with "Captain America (Movies)", its metatag "Marvel Cinematic Universe" should not appear in your Fandoms box.

Environment

None

Status

Assignee

Unassigned

Reporter

redsummernight

Roadmap

Orphaning
Users

Priority

Medium

Affects versions

0.9.250

Fix versions

None

Components

BackEnd

Difficulty

Medium

Required Access Level

None

Milestone

Internal 0.9
Configure