code as below:
```
db.postspreads.find({"location":{"$nearSphere":{"$geometry":{"type":"Point","coordinates":[113.558206,22.159933]},"$maxDistance":1}},"countavailablespreads":{"$gt":0},"timestamp":{"$gt":1430409600},"accountid":{"$ne":254695}}, {'_id':1}).limit(100).explain()
{
"cursor" : "S2NearCursor",
"isMultiKey" : false,
"n" : 100,
"nscannedObjects" : 25626,
"nscanned" : 25626,
"nscannedObjectsAllPlans" : 25626,
"nscannedAllPlans" : 25626,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 239,
"nChunkSkips" : 0,
"millis" : 2244,
"indexBounds" : {
},
"server" : "DB-SH-01:27017",
"filterSet" : false
}
```
i dont know why it will cost more than 2 seconds.
document structure:
```
{
"_id":ObjectId("55483f3e297b5043c7a2b099"),
"postid":NumberLong(142462),
"spreadid":"55474131297b5043c6451ac0",
"accountid":NumberLong(257074),
"location":{
"type":"Point",
"coordinates":[
113.558206,
22.159933
]
},
"city":"null",
"country":"null",
"type":NumberLong(1),
"countspreads":NumberLong(51),
"countavailablespreads":NumberLong(51),
"timestamp":NumberLong(1430798142),
"createdtime":ISODate("2015-05-05T03:55:42Z")
}
```
please pay attention on location node.
please advise how to optimize it.
thank you in advantage.