Query with sort ascending get response very slow

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Works as Designed
    • Priority: Major - P3
    • None
    • Affects Version/s: 4.0.2
    • Component/s: Index Maintenance
    • None
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      I have 30_000_000 Documents: {_id:long, owner:string, content:string}
      I create index for 'owner' field

      I have a query: { "_id":

      { $gt: NumberLong(22047817660001) }

      , "ci": "0938186066:0938186061" }

         + Case 1: do query with sort = descending and limit = 50  => Receiving data in 0.002s

         + Case 1: do query with sort = ascending and limit = 50  => Receiving data in 9s

       

       

            Assignee:
            Nick Brewer (Inactive)
            Reporter:
            Lê Trung Trung
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: