Indexing mongodb

[chrisaq]

Indexes I've added so far, but might be useful to put in a post install script or similar:

image collection

db.image.ensureIndex({"publicKey": 1, "imageIdentifier": 1}, { background: true })
db.image.ensureIndex({"publicKey": 1, "updated": -1}, { background: true })
db.image.ensureIndex({"publicKey": 1, "added": -1}, { background: true })
db.image.ensureIndex({"user": 1, "imageIdentifier": 1}, { background: true })
db.image.ensureIndex({"user": 1, "added": -1}, { background: true })
db.image.ensureIndex({"user": 1, "updated": -1}, { background: true })

imagevariation collection

db.imagevariation.ensureIndex({"user": 1, "imageIdentifier": 1}, { background: true })
db.imagevariation.ensureIndex({"user": 1, "imageIdentifier": 1, "width": 1}, { background: true })

[chrisaq]

As suggested I removed these indexes:
db.image.ensureIndex({"publicKey": 1, "imageIdentifier": 1}, { background: true })
db.image.ensureIndex({"publicKey": 1, "updated": -1}, { background: true })
db.image.ensureIndex({"publicKey": 1, "added": -1}, { background: true })

It worked out fine.

[christeredvartsen]

This should be provided as scripts that comes with Imbo that can create the indexes, and mentioned in the docs as well.