Erase multiple range records all at once in MongoDB

Question

Erase multiple range records all at once in MongoDB

I have a challenge where I need to delete 50% of the records from my MongoDB collection, specifically targeting the oldest ones.

Here's the script I currently have:

var count = Twitter_tweets.find().count();
var limit = Math.round(count *.5);
var tweets = Twitter_tweets.find().sort({$natural:1}).limit(limit);

_.each(tweets,function(tweet){
    Twitter_tweets.delete({_id : tweet._id});
});

Since I'm using 'each' to iterate through and delete each record individually, I'm wondering if there is a way to delete all records at once with a single MongoDB instruction. Unfortunately, I haven't been able to find this information on Google. Is there a way to achieve this in MongoDB?

javascript mongodb meteor

Answer 1

Answer №1

While I can't provide the exact Meteor code for this conversion, I can offer a potential strategy:

let totalTweets = Tweets_collection.find().count();
let deleteLimit = Math.floor(totalTweets * 0.5);
let middleTweet = Tweets_collection.find().sort({_id: 1}).skip(deleteLimit).limit(1).fetch()[0];

Tweets_collection.remove({_id: { $lt: middleTweet._id } });

The concept here is to fetch the document with the _id that falls in the middle of the collection and remove all documents with lower _id values relative to it. In general, the _id should be incrementally increasing unless there have been manipulations.

Answer 2

While I can't provide the exact Meteor code for this conversion, I can offer a potential strategy:

let totalTweets = Tweets_collection.find().count();
let deleteLimit = Math.floor(totalTweets * 0.5);
let middleTweet = Tweets_collection.find().sort({_id: 1}).skip(deleteLimit).limit(1).fetch()[0];

Tweets_collection.remove({_id: { $lt: middleTweet._id } });

The concept here is to fetch the document with the _id that falls in the middle of the collection and remove all documents with lower _id values relative to it. In general, the _id should be incrementally increasing unless there have been manipulations.

Erase multiple range records all at once in MongoDB

Answer №1

Similar questions

Items vanish once collected from the cookie shop

How can lazy loading of images be implemented in HTL code in AEM 6.5?

Instructions for adding a name to a string based on certain conditions

How do you typically start off a state variable of type number when working with React?

Accessing files is not feasible with Firefox 17.0.1 extension

Adjust image source based on media query (CSS or JavaScript)

Submit form using jQuery after making an AJAX request with jQuery's $

Is it possible to create a personalized serialize form when sending an AJAX POST request

Using jQuery to Extract HTML Content from a JSON Object

Creating a form in NextJS to securely transfer user input data to MongoDB

What could be causing my CSS navigation toggle button to malfunction?

Having trouble loading JSON data into HTML using jQuery

Removing the initial 0 from the input

Is it possible for me to pass a reference to a specific object's instance function?

How can I extract the return value of a JSON object and store it in a variable?

Showing information from an ajax Json onto a ul element within web forms using asp.net

The require statement in Vue.js is failing to function dynamically

Encountering a problem with the persistent JavaScript script

The directive binding value is accurate, however it is failing to return a true result

Having trouble setting the locale in momentJS?