Add support of $setOnInsert modifier for upsert [DATAMONGO-630]

[spring-projects-issues]

Anton opened DATAMONGO-630 and commented

Please add support of $setOnInsert modifier for upsert introduced in mongo 2.4 https://jira.mongodb.org/browse/SERVER-340. It will significantly decrease disk I/O in case of bulk-load. In our system multiple threads should create records in the same collection base on input data, _id is a hash of essential values. In our case upsert is only one way how to manage atomic operations, but without setOnInsert this operation is very slow on sharded environment.

Method:

@Override
public void upsertCluster(ClusterKey clusterKey) {
    FindAndModifyOptions options = new FindAndModifyOptions().upsert(true);
    Query query = query(Criteria.where(ID).is(clusterKey.getId()));
    Update update = new Update();
    update.set(CLUSTERS_KEY, clusterKey);
    getMongoTemplate().findAndModify(query, update, options,
        ClusterMongoDocument.class, getDocumentInformation().getCollectionName());
}

Please suggest how can we optimize the method.

Thank you,
Anton

---

2 votes, 4 watchers

[spring-projects-issues]

Anton commented

Hi, do you have any update when this feature will be implemented?
Thank you

[spring-projects-issues]

Becca Gaspard commented

I took at stab at it.. :)
#70

[spring-projects-issues]

Becca Gaspard commented

Also, here is the workaround I have been using for now... :)

class MyUpdate extends Update {
   public MyUpdate setOnInsert(String key, Object value) {
      super.addMultiFieldOperation("$setOnInsert", key, value);
      return this;
   }
}

MyUpdate update = (new MyUpdate()).setOnInsert("key", "value");