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

Exit BSON parsing early on retrieving data.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: 2.6.1
    • Fix Version/s: Backlog
    • Component/s: Performance
    • Labels:
      None

      Description

      We treat BSON as having unique keys for all values.

      When searching for matching documents we use an early exit strategy, as soon as we find the value or values we are looking for we skip to the next document.

      However this only benefits us in a count - anything that does a projection, including aggregation does not take advantage of this and therefore processes, and more importantly pages in more data than is required. With the removal of covered indexes for aggregation this becomes more important.

      I suggest, when projecting, once we have the data we need we do not page the rest of the document in.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              backlog-query-execution Backlog - Query Execution
              Reporter:
              john.page John Page
              Participants:
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: