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

indexed geo search slower than index-less naive search

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 1.7.3
    • Fix Version/s: 1.9.0
    • Component/s: Geo, Indexing, Performance
    • Labels:
      None
    • Environment:
      Same issue seen w/1.6.4 on Linux 64 and on 1.7.3 w/ OS X 64bit.

      Description

      I would like to do geo queries against a collection with 1M docs or
      more. I'm seeing terrible performance for geo queries, even though
      the outputs from find() commands and getIndexes() indicate that a 2d
      geo index is being used for the query.

      At large sizes (1M), an indexed geo query is slower than a naive javascript search. At 100K commits, the geo search is faster.

      More details on the mongodb-user list thread at:

      http://groups.google.com/group/mongodb-user/browse_thread/thread/7bcce8a4d58c44c3

      Full data from mongodump on the db is attached (compressed).

        Attachments

          Activity

            People

            • Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: