Global Victory Aggregate taking 2+ seconds to respond

[Maelstromeous]

This aggregate loads a lot of the homepage statistics and it's extremely under performant. It's currently cached by Redis but I believe that it's ineffective and isn't caching properly.

This appears to have been worsened by the recent database migration.

Solution 1:

1. Set the TTL to 24 hours for the aggregate on the endpoint
2. Using the new internal API call, have it invalidate the cache upon instance end
3. Regenerate the cache

Solution 2:

1. Investihate why the query is taking so long to respond in Mongo.
2. Attempt to fix the issue.

Solution 3:

1. Implement pagination on the endpoint and the website, and bring the data in chunks