Updating multiple records in MongoDB using ObjectID as the criteria for selection can be achieved by leveraging the

Question

Updating multiple records in MongoDB using ObjectID as the criteria for selection can be achieved by leveraging the

I am currently working in the Mongo shell on Ubuntu and have a Collection with 1 million documents. My goal is to select 50,000 records based on their ObjectID and update one of the values.

Is there a way to specify a range of 50,000 documents for the update operation? The exact selection of documents within this range isn't important, I just need to isolate this number of records to measure performance time when updating using the primary id.

I attempted to run the following code without success:

use Assignment
var _start = new Date()
db.FlightsDate.update({$set:{Airtime: 8888}}).limit(50000).hint({_id:1});
var _end = new Date();
print("Time to Bulk Update AirTime key for 50000 documents… " + ((_end - _start)/1000));

It seems that MongoDB requires a query to be included in the command to specify which documents should be updated. I now understand from other sources that the .limit method might not limit the number of records updated by an .update operation.

If anyone can suggest a method to define the number of records to update, I would greatly appreciate it.

Thank you for your advice.

Best regards, Jon

javascript mongodb mongodb-query

Answer 1

Answer №1

If you're seeking a range that encompasses 50,000 documents from the collection, it's best to first query and identify the starting and ending documents of your range. Then, you can apply this range specification to your update.

var start_id = db.FlightsDate.find({}).limit(1).toArray()[0]._id;
var end_id = db.FlightsDate.find({}).skip(49999).limit(1).toArray()[0]._id;

var _start = new Date();
db.FlightsDate.update(
    { "_id": { "$gte": start_id, "$lte": end_id } },
    { "$set"; { "Airtime": 8888 } },
    { "multi": true }
);

var _end = new Date();
(_end - _start) / 1000;

If you then need the next 50,000 in an additional range:

var start_id = db.FlightsDate.find(
    { "_id": { "$gt": end_id } }
).limit(1).toArray()[0]._id;

var end_id = db.FlightsDate.find(
    { "_id": { "$gt": end_id } }
).skip(49999).limit(1).toArray()[0]._id;

Repeat this process for the next set of documents.

It's crucial to know where to begin and end within a range to update only 50,000 documents without any other filtering criteria.

Additionally, note the use of "multi" in the update method. By default, .update() only updates one document unless specified otherwise with "multi" to update all documents within the range.

Answer 2

If you're seeking a range that encompasses 50,000 documents from the collection, it's best to first query and identify the starting and ending documents of your range. Then, you can apply this range specification to your update.

var start_id = db.FlightsDate.find({}).limit(1).toArray()[0]._id;
var end_id = db.FlightsDate.find({}).skip(49999).limit(1).toArray()[0]._id;

var _start = new Date();
db.FlightsDate.update(
    { "_id": { "$gte": start_id, "$lte": end_id } },
    { "$set"; { "Airtime": 8888 } },
    { "multi": true }
);

var _end = new Date();
(_end - _start) / 1000;

If you then need the next 50,000 in an additional range:

var start_id = db.FlightsDate.find(
    { "_id": { "$gt": end_id } }
).limit(1).toArray()[0]._id;

var end_id = db.FlightsDate.find(
    { "_id": { "$gt": end_id } }
).skip(49999).limit(1).toArray()[0]._id;

Repeat this process for the next set of documents.

It's crucial to know where to begin and end within a range to update only 50,000 documents without any other filtering criteria.

Additionally, note the use of "multi" in the update method. By default, .update() only updates one document unless specified otherwise with "multi" to update all documents within the range.

Updating multiple records in MongoDB using ObjectID as the criteria for selection can be achieved by leveraging the

Answer №1

Similar questions

When I refresh the page in Angular2, the router parameters do not get loaded again

I am facing a dilemma with Expressjs when it comes to managing numerous users simultaneously

What is the process of uploading files using Ajax?

To retrieve a CSV file on the frontend, simply click a button in an AngularJS application that communicates with NodeJS and ExpressJS

Executing Python script via AJAX or jQuery

Steps to verify the current time and execute a task if it matches the designated time

Is there a way to remove a portion of a string?

After several interactions, the CSS files fail to load

A Step-by-Step Guide to Launching PDF Blob from AJAX Response in a Fresh Chrome Tab

Eliminate the presence of core-js in the nextjs bundle

Deactivate the date when it reaches 8 in the current date count using ajax, php, and mysql

What is the best way to display a button only during office hours from 9am to 5pm using React.js or JavaScript?

What can cause the reactive value to fail to update in a Vue template?

Validating complex ASP.NET MVC objects using AngularJS

Node.js's module-only scope concept allows variables and functions defined within

Typescript enhances Solid JS by using the "as" prop and the "component" prop

Setting up Npm Sequelize Package Installation

Is the Vuex mutation properly formatted?

create new Exception( "Invalid syntax, expression not recognized: " msg );

Unable to dynamically change the value of the submit button using angular.js