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

Count of Geo Querys of Millions of Documents Extremely Slow

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Critical - P2
    • Resolution: Works as Designed
    • 2.2.0, 2.4.0
    • None
    • Geo
    • None
    • Linux (EC2)
      OSX

    Description

      I have a 5M record dataset including Geo locations upon which I want to search to find points within a selected area.

      The operation yields results quickly but I need a count of the points in the area as well. If I make a selection of a city or entire state on this data the count query takes 45 seconds or more to execute.

      There is a similar problem if I want to sort the results of a find (NOT a count in this case) regardless of indexing.

      This thread has additional info

      https://groups.google.com/forum/#!searchin/mongodb-user/geo$20performance/mongodb-user/UQNiXAHZHP0/2nu9unVFQ3QJ

      Attachments

        Activity

          People

            hari.khalsa@10gen.com hari.khalsa@10gen.com
            mattx Matthew Cross
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: