Skip to content

Fix issue search optimization in GraphQL

Heinrich Lee Yu requested to merge fix-issue-search-optimization-graphql into master

What does this MR do and why?

This enables the CTE search optimization when searching issuables via GraphQL.

When going through GraphQL resolvers, a symbol is passed in as the sort param of the IssuesFinder. This fixes our search optimization which depends on the given sort order to take symbols into account.

Related to gitlab-foss#40379 (comment 685212464) and gitlab-jh/gitlab#229 (closed)

How to set up and validate locally

  1. Open the "New Issue" form
  2. Type a few characters into the title field
  3. Check the GraphQL request in the performance bar and verify that the query for issues uses a CTE

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Heinrich Lee Yu

Merge request reports