Mongoose + NodeJS

Question

I have in my mongoDB more than 50000 entries with an ID (in one collection).

I would like to get only the ID (and not the other infos).

In server.js, I connect to mongoDB via mongoose:

mongoose.connect('mongodb://10.3.5.12/mydb');

I need to iterate all the 50 000 entries to check the ID, check the duplicates and store in a list.

Do I need to create a controller? It will be very heavy with 50 000 entries? Any idea how I can proceed?

var listId= [];
...
listId.push(id);

[EDIT] Could I try something like that with mongoose?

    MyModel.find().distinct('id', function(error, id) {
        // ids is an array of all ObjectIds
       var listId= [];
       ...
       listId.push(id);
    });

Thanks for your help!

So you're basically trying to get all id's in the database, removing all duplicates? — Joachim Isaksson
– Joachim Isaksson, Commented Oct 9, 2014 at 16:56
check mapreduce : glassonionblog.wordpress.com/2012/03/19/… — xShirase
– xShirase, Commented Oct 9, 2014 at 17:01

mr.freeze · Accepted Answer · 2015-11-23 15:03:52Z

1

If you're using Mongoose 3.x+ you can do this:

MyModel.find().distinct('_id', function(error, ids) {
    // ids is an array of all ObjectIds
});

answered Nov 23, 2015 at 15:03

mr.freeze

14.1k5 gold badges39 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mongoose + NodeJS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related