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

Implement operation to check if documents in collection have changed

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Catalog, Querying
    • None
    • Query Execution
    • QE 2021-08-09

      Is there a way to let users determine "has db.myCollection changed at all since <time>" that is more lightweight than opening a change stream and listening for change events?

      It would be useful to be able to check if a collection has changed in any way since some time.

      Motivation

      The atlas search "synonyms" feature defines synonym data in a user collection. Search automatically detects changes to that collection, and updates synonyms artifacts on change.

      Search uses change streams to detect changes to that collection today - but does not have a way to incrementally modify synonym artifacts given change event information. mongot must replicate "from scratch" on each change.

      Change streams are an effective way to detect a change for a collection - but, if possible, we would be able to ask "has this collection changed?" in a less resource-intensive way.

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            evan.nixon@mongodb.com Evan Nixon
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: