/
Forum Indexes Round 2

Forum Indexes Round 2

Owned by Christopher Lee (Deactivated)
Last updated: Oct 29, 2015

DEVOPS-3170 - Getting issue details... STATUS

Remove these:

comment_thread_id_1

author_id_1

last_activity_at_-1

votes.down_1__type_1

votes.up_1__type_1

delete_spam_1

Modify these:

Remove _type_1_commentable_id_1_context_1_pinned_-1_created_at_-1

{
        "v" : 1,
        "key" : {
            "_type" : 1,
            "commentable_id" : 1,
            "context" : 1,
            "pinned" : -1,
            "created_at" : -1
        },
        "name" : "_type_1_commentable_id_1_context_1_pinned_-1_created_at_-1",
        "ns" : "comments-prod.contents",
        "background" : true
    },

and re add as,

db.contents.ensureIndex({"_type":-1,  "course_id":1, "commentable_id":1, "context":1, "pinned":-1, "created_at":-1}, {"background":true})

Add these:

db.contents.ensureIndex({"_type":-1, "course_id":1, "endorsed":-1, "pinned":-1, "last_activity_at":-1, "created_at":-1}, {"background":true})
db.contents.ensureIndex({"_type":-1, "course_id":1, "endorsed":-1, "pinned":-1, "votes.point":-1, "created_at":-1}, {"background":true})
db.contents.ensureIndex({"_type":-1, "course_id":1, "endorsed":-1, "pinned":-1, "comment_count":-1, "created_at":-1}, {"background":true})

Related content