Adding index to MongoDB causes empty results

Question

Hey all,

I have a mondoDB with data in it at the moment which I am querying with Ruby on Rails. I am looking to index the database to speed things up a bit.

I read the mongoDB documentation and followed the instructions on how to add a index, like so:

db.collection.ensureIndex({"key": 1})

This returns true and returns this in the console:

building new index on { key: 1.0 } for db.collection...done for 10192 records

However, when I go back to the Ruby on Rails application no results are return and when I drop the indexes everything returns back to normal.

Does anyone know why this might be happening.

Cheers

Eef

Answer 1

What version of the db are you using? Can you send a sample object and the results of the query beforehand?

Answer 2

more info would help such as some output from the shell with the query, its output, ensureindex, then query output again, and detailed version #s

you can get help in http://groups.google.com/group/mongodb-user or on the IRC channel