I want to find a point in a circle on a sphere and execute the command:
db.places.find( { loc :
{ $geoWithin :
{ $centerSphere :
[ [ -88 , 30 ] , 10 / 3963.2 ]
} } } ).explain()
found that it took five or six seconds to query the results.
nReturned=totalKeysExamined & totalDocsExamined
nReturned=390000 totalKeysExamined = 430132 totalDocsExamined = 430013
loc has added the 2dsphere index. The total amount of data is only more than 2 million pieces of data. I don"t understand why the query results are so slow.