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
571 views
in Technique[技术] by (71.8m points)

mongodb 视图 查询很慢

各位好,我在mongodb中 为一个表创建了一个视图,但是查询视图的时候,速度非常慢, 对于原表字段是 tags 他是一个数组,元素是字符串类型,我在原表中加了索引, 查询原表也很快,但是view视图查询 就慢的要命,所以想请问如何提醒视图的查询速度.谢谢

我创建view的语句是(golang):

err := s.env.MongoCli.CreateView(ctx, model.PodTagsViewTable, model.PodTable, []bson.M{
        {"$project": bson.M{
            "tags": 1,
        }},
        {"$unwind": "$tags"},
        {"$group": bson.M{"_id": "$tags", "count": bson.M{"$sum": 1}}},
    })

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
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

...