Skip to content

Configuring indexes in MongoDB for optimizing Atomhopper performace #253

@frankzappasmoustache

Description

@frankzappasmoustache

We've set up a Atomhopper server on top of a mongoDb database. After posting a lot of data we experienced slower response times and noticed that we should have configured an index for DateLastUpdated.

After setting that up we have still experienced slow response times on a 4 million document collection when loading the feed like this:

http:////obo/feed

Or when searching like this:

http:////obo/feed?format=json&search=

Is it possible to get more info on the index configuration for mongo? We suspect more indexes are needed. We have played around adding something like this (but still it takes time to search):

    {
            "v" : 1,
            "key" : {
                    "feed" : 1,
                    "categories.term" : 1,
                    "dateLastUpdated" : 1
            },
            "ns" : "atomhopper.obo.feed",
            "name" : "feed_1_categories.term_1_dateLastUpdated_1"
    },
    {
            "v" : 1,
            "key" : {
                    "feed" : 1,
                    "dateLastUpdated" : 1
            },
            "ns" : "atomhopper.obo.feed",
            "name" : "feed_1_dateLastUpdated_1"
    }

]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions