Investigate if adding a projection to the samples collection query degrades perf too much

XMLWordPrintableJSON

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

      Right now for persisted samples we fetch the entire document from the sample. We could use a query like 

      find({_id predicate}, {<all of the necessary metafields>, docs.a: 1, docs.b: 1, ...})

      but that would make the query not express-eligible.

      Now that we are implementing the document chaining approach, it may make sense to apply the projection so that we are not fetching/iterating over irrelevant fields since the document chaining query will not be express-eligible (I think).

            Assignee:
            Unassigned
            Reporter:
            Militsa Sotirova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: