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

indexed geo search slower than index-less naive search

XMLWordPrintableJSON

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 1.9.0
    • Affects Version/s: 1.7.3
    • Component/s: Geo, Index Maintenance, Performance
    • Labels:
      None
    • Environment:
      Same issue seen w/1.6.4 on Linux 64 and on 1.7.3 w/ OS X 64bit.

      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).

        1. db_geo_slow.tgz
          45.57 MB

            Assignee:
            greg_10gen Greg Studer
            Reporter:
            brandonh Brandon Heller
            Votes:
            3 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: