Skip to content

Performance problems with querying for a large numbers of redirects #409

Description

@Scotchester

We have an, ah, unseemly number of redirects (almost 100,000), and it seems like it's starting to timeout on the GraphQL query for them at this point. It's not entirely clear why it has started to do this, because the number of redirects hasn't jumped dramatically, but it seems to have been triggered by an upgrade from 0.18 to 0.19.1. Perhaps some kind of performance regression? (Several GraphQL subdependencies came along with that update, too.)

We've since upgraded to 0.24, which is the latest version that supports the version of Wagtail we're currently running (4.2.4 – yeah, I know…), but it still takes a very long time, often timing out after trying for 60 seconds.

If there isn't a performance regression that can easily be diagnosed and fixed, some other potential ways to address this could be:

  • Enable pagination support on the redirects query
  • Allow fetching only redirects added/modified after a certain datetime, so the frontend can ask for only what's changed since it last updated its redirects cache

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions