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

Find on view acquires collection 3 times

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution

      The way this type of query is processed requires acquiring a collection (and a WT snapshot) 3 times:

      1. In the find command, where we see it's a view and defer to the aggregation framework after releasing the acquisition (and the WT snapshot)
      2. In the aggregation comand, where we see it's a view, so we resolve it and reenter after releasing the acquisition
      3. Again in the aggregation command.

      In PERF-4259 we saw that removing one of the acquisitions improves performance of Queries.IdentityView.TwoInts about 5%, removing the 2 extra acquisitions would be ideal.

            Assignee:
            Unassigned Unassigned
            Reporter:
            daniel.gomezferro@mongodb.com Daniel Gomez Ferro
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: