Copy between collection filtered by a third collection in other database with mongoDB
up vote
0
down vote
favorite
I have three collections, I want to move data from collection A to B filtered by a collection C that is in another database.
Problem is that MongoDb fail, no matter the query I can't move more than 100 document and fail, I think I need an optimized query, I doing this:
db.getSiblingDB('OTHERDATABASE').C.find().forEach(function (d) {
db.getCollection('A').find({_id:d._id}).forEach(function (x) {
db.getCollection('B').insert(x);
})
});
php mongodb mongodb-query
add a comment |
up vote
0
down vote
favorite
I have three collections, I want to move data from collection A to B filtered by a collection C that is in another database.
Problem is that MongoDb fail, no matter the query I can't move more than 100 document and fail, I think I need an optimized query, I doing this:
db.getSiblingDB('OTHERDATABASE').C.find().forEach(function (d) {
db.getCollection('A').find({_id:d._id}).forEach(function (x) {
db.getCollection('B').insert(x);
})
});
php mongodb mongodb-query
MongoDB fails how exactly?
– malarzm
Nov 7 at 23:17
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have three collections, I want to move data from collection A to B filtered by a collection C that is in another database.
Problem is that MongoDb fail, no matter the query I can't move more than 100 document and fail, I think I need an optimized query, I doing this:
db.getSiblingDB('OTHERDATABASE').C.find().forEach(function (d) {
db.getCollection('A').find({_id:d._id}).forEach(function (x) {
db.getCollection('B').insert(x);
})
});
php mongodb mongodb-query
I have three collections, I want to move data from collection A to B filtered by a collection C that is in another database.
Problem is that MongoDb fail, no matter the query I can't move more than 100 document and fail, I think I need an optimized query, I doing this:
db.getSiblingDB('OTHERDATABASE').C.find().forEach(function (d) {
db.getCollection('A').find({_id:d._id}).forEach(function (x) {
db.getCollection('B').insert(x);
})
});
php mongodb mongodb-query
php mongodb mongodb-query
asked Nov 7 at 15:22
Michael
13
13
MongoDB fails how exactly?
– malarzm
Nov 7 at 23:17
add a comment |
MongoDB fails how exactly?
– malarzm
Nov 7 at 23:17
MongoDB fails how exactly?
– malarzm
Nov 7 at 23:17
MongoDB fails how exactly?
– malarzm
Nov 7 at 23:17
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53192475%2fcopy-between-collection-filtered-by-a-third-collection-in-other-database-with-mo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
MongoDB fails how exactly?
– malarzm
Nov 7 at 23:17