[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,
Closing out this ticket. Please let us know if you have any further questions. Also for questions like this probably the best place to ask is the community forum

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?
What is the write distribution like?

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?

Generated at Thu Feb 08 03:06:47 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.