Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
233 views
in Technique[技术] by (71.8m points)

javascript - MongoDB: best way to update the field using the value of another field

I have a code in NodeJS that updates the fields of a collection but it is very slow. My collection contains +16 million documents, do any of you know a better way to do this?

        const db = client.db("db");
        const collection = db.collection("collection");

        var cursor = product.find({});

        var manipulator = function(document) {
            document.fieldCopy = document.field;
            
            return { $set: document };
        };

        while (await cursor.hasNext()) {
            var thisdoc = await cursor.next();
            var newDoc = manipulator(thisdoc);
            product.updateOne({ "_id": thisdoc['_id'] }, newDoc);
        };

MongoDB version: 4.0.22

Sorry for the bad English!


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...