Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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里执行时,右下角的时间却是108msimage

为什么呢?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
3.7k views
Welcome To Ask or Share your Answers For Others

1 Answer

等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share

548k questions

547k answers

4 comments

86.3k users

...