Avoid unnecessarily fetching documents while updating

XMLWordPrintableJSON

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

      update operations can currently FETCH the same document multiple times. This happens when the index being used includes a key that the update is modifying and the modification places the new entry later in the index relative to the traversal that is happening. We successfully use the record ids to avoid modifying the document multiple times, but we currently FETCH it more than once. This seems unnecessary as we should be able to use the record id in the index to confirm that no further work is necessary for the document.

              Assignee:
              [DO NOT USE] Backlog - Query Optimization
              Reporter:
              Chris Harris
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

                Created:
                Updated: