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

Query with sort ascending get response very slow

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Works as Designed
    • Icon: Major - P3 Major - P3
    • None
    • 4.0.2
    • Index Maintenance
    • None
    • ALL

    Description

      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

       

       

      Attachments

        Activity

          People

            nick.brewer Nick Brewer
            letrungtrung1987 Lê Trung Trung
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: