T1表存储某区域的边界,并创建了2dsphere索引,大概有1300条数据;现在要查询某个点是否在这个区域内,如下:
db.T1.createIndex({'Loc':'2dsphere'})
db.T1.find(
{
Loc: {
$geoIntersects: {
$geometry: {
"type": "Point",
"coordinates": [118.9821, 26.1]
}
}
}
}
)
explain时,执行耗时是34ms
"executionStats": {
"executionSuccess": true,
"nReturned": 3,
"executionTimeMillis": 34,
"totalKeysExamined": 11,
"totalDocsExamined": 3,
...
}
但实际在navicat里执行时,右下角的时间却是108ms
为什么呢?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…