In new aggregation framework, $sort, $limit in the pipeline seems loading all the matched data into memory. When we tried to improve the performance by leveraging multi thread aggregation, this makes it much slower than single thread

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: 2.1.1
    • Component/s: Aggregation Framework
    • None
    • Environment:
      OSX 10.6, Java, mongodb is built from Dec. 15 master branch.
    • OS X
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      Overall new aggregation framework is faster than map-reduce in our application. But when I tried to further improve the performance by sending multiple aggregation commands in multiple threads, then get the final aggregation done in app space, I noticed each thread will load lot of data to memory which makes each command take minutes to finish. (I do have index on sort key)

            Assignee:
            Chris Westin (Inactive)
            Reporter:
            Xiaofeng Wu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: