Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
4.0k views
in Technique[技术] by (71.8m points)

mongodb实际查询时间大于explain里的时间

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

为什么呢?


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...