[SERVER-4720] shard key Created: 19/Jan/12 Updated: 11/Jul/16 Resolved: 10/Feb/12 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 2.0.2 |
| Fix Version/s: | None |
| Type: | Question | Priority: | Minor - P4 |
| Reporter: | Brett Goldstein | Assignee: | Steve Francia |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: |
| Description |
|
Looking at our document set it seems like the logical sharding key would be the location. Can I use a location array as a shard key? |
| Comments |
| Comment by Steve Francia [ 10/Feb/12 ] |
|
Brett, https://groups.google.com/forum/?fromgroups#!forum/mongodb-user |
| Comment by Brett Goldstein [ 24/Jan/12 ] |
|
i think I am going to try longitude as the key for now. will let you know how it goes. |
| Comment by Eliot Horowitz (Inactive) [ 20/Jan/12 ] |
|
What kind of queries are the most common? |
| Comment by Brett Goldstein [ 19/Jan/12 ] |
|
any creative thoughts on how to approach this? |
| Comment by Eliot Horowitz (Inactive) [ 19/Jan/12 ] |
|
No - you can't shard on a geo field yet. |
| Comment by Brett Goldstein [ 19/Jan/12 ] |
| { "_id" : ObjectId("4ef9e4a943b1705e7248d6d6"), "location" : [ 41.111111111111, -87.2222222222 ], "type" : "threeoneone", "type_code" : "POTHOLE", "datetime" : "1095070000" } |
| Comment by Eliot Horowitz (Inactive) [ 19/Jan/12 ] |
|
Can you send a sample document? |