Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-8359

Autocomplete slow with large queries is slow

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • None
    • Environment:
      OS:
      node.js / npm versions:
      Additional info:
    • Developer Tools
    • 3

      Not confirmed, but someone reported that they have very large queries (with a lot of items in a $in). And when typing in the query bar it is now slower after the query history autocomplete changes. This is likely because we're trying to match and fuzzy match some pretty large items.

      This ticket involves restricting how much we'll fuzzy search on saved queries for this autocomplete. The amount of fields, amount of saved queries, and the length of each field or the total saved query length should be restricted for this optimization. We'd rather it be speedy than let them choose a past query if it would make typing slow, Eeven if it comes at the cost of some loss in accuracy for suggesting queries.

      Slack thread: https://mongodb.slack.com/archives/G2L10JAV7/p1728418370784179 

            Assignee:
            Unassigned Unassigned
            Reporter:
            rhys.howell@mongodb.com Rhys Howell
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: