We're planning on changing our shard key. We'd like your opinion on whether it makes sense or not.

XMLWordPrintableJSON

    • Type: Question
    • Resolution: Done
    • Priority: Critical - P2
    • None
    • Affects Version/s: 2.0.3
    • Component/s: Sharding
    • None
    • Environment:
      Linux
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      We have a GIS based database. All documents contain longitude and latitude. Currently we have our shard key set to longitude. We are considering changing it to a combination of longitude and latitude. We believe that, in doing so, we will not only greatly increase the cardinality of keys, but will also distribute our data more evenly across the shards. We also expect to see an improvement in the time it takes to load and query data. We'd like your opinion on this.
      Thanks in advance for you help.

            Assignee:
            Unassigned
            Reporter:
            Tim Shinnick
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: