geoNear performance on low-end machine

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Done
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Geo, Performance, Querying
    • None
    • ALL
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      I also noticed a slow using Geonear with 2dsphere index,
      but what is slow, im pretty new with mongo so imnot sure ,
      here is the context:
      i make a full scan over 35000 item collections with no limit result,
      it takes about 5s on a 1core vm google cloud machine.
      If its not a normal things (i guess) , i can provide you the collection for reproduce pb;
      We just discover mongo and love it but this limitation is a serious blocker for us project.

      db.runCommand({ geoNear: "tablegui", near: [2.298800, 48.854355], spherical: true, distanceMultiplier: 6371 , maxDistance:2000/6371 , limit:37000 });
      
      "stats" :
      { "nscanned" : NumberLong(810310), "objectsLoaded" : NumberLong(810310), "avgDistance" : 325.45877488880984, "maxDistance" : 701.9530252234592, "time" : 5511 } , "ok" : 1
      

            Assignee:
            Siyuan Zhou
            Reporter:
            guipulsar
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: