Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-43683

Make find command with allowDiskUse option work against a view

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.3.1
    • Component/s: Querying
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible
    • Sprint:
      Query 2019-10-21

      Description

      Today, a find command can be executed against a view which contains blocking stages like $sort or $group that can consume a lot of memory. These stages will fail at runtime if the data size exceeds some memory threshold. If the user runs an aggregate command against the view, they can specify that disk use is allowed during execution of the query. The execution engine will relieve memory consumption by spilling to disk, allowing the query to succeed.

      The same cannot currently be achieved with a find command. However, we recently added support for the allowDiskUse option in the find command: see related ticket SERVER-42077. This ticket tracks the work to make sure that the allowDiskUse option is respected when executing a find command against a view, and to add an integration test proving this works correctly.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              david.storch David Storch
              Reporter:
              david.storch David Storch
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: