CODEWITHSUNDEEP
mongodbbatch-filebulkupsertnosql
StackUnderflow
StackUnderflow

Reputation: 25368

Bulk update/upsert in MongoDB?

Is it possible to do bulk update/upsert (not insert) in MongoDB?

If yes, please point me to any docs related to this?

Thanks

Upvotes: 13

Views: 17865

Answers (3)

unique
unique

Reputation: 31

mongo can execute .js file. you can push all you update commands in a js file.

t.js

db.record.update({md5:"a35f10a8339ab678612d1f86be08b81a"},{$set:{algres:[]}},false,true);
db.record.update({md5:"a35f10a8339ab678612d1f86be08b81b"},{$set:{algres:[]}},false,true);

then, mongo 127.0.0.1/test t.js

Upvotes: 3

britztopher
britztopher

Reputation: 1234

Bulk updates can also be done in batches as found in the documentation:

MongoDB Bulk Methods

I use these to import CSV files that I need to massage a bit before importing the data. Its kinda slow when dealing with updates, but it did my 50K document updates in about 83 seconds, which is far slower than mongoimport command.

Upvotes: 1

Justin Jenkins
Justin Jenkins

Reputation: 27080

You can use the command line program mongoimport it should be in your MongoDB bin dir ...

There are two options you'll want to look into to use upsert ...

--upsert insert or update objects that already exist
--upsertFields arg comma-separated fields for the query part of the upsert. You should make sure this is indexed

More info here: http://www.mongodb.org/display/DOCS/Import+Export+Tools

Or just do ...

$ mongoimport --help

Upvotes: 4

Related Questions