[SERVER-20211] Cross collection batch operation Created: 31/Aug/15  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: Performance, Usability
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Minor - P4
Reporter: Nick Judson Assignee: Backlog - Query Optimization
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-2172 Support Batching Mixed Operations Aga... Backlog
Related
Assigned Teams:
Query Optimization
Participants:

 Description   

It may be useful to allow bulk operations to span collections. I have found that bulk operations tend to be significantly more performant (than multiple discreet operations). In my workflow I have come across several scenarios which would benefit from this feature.

For example, upon completion of a certain program operation, I need to update one table and insert a summary document in another. These two operations are always tied together but it doesn't make sense for them to be within the same collection.

By extension, being able to batch multiple operations across multiple databases would also be useful in my workload. In my case I have 1 insertion thread per collection (and can have many hundreds of threads per collections). A cross-database batch operation may allow me to use a small thread pool to perform the same operation in a more efficient manner.



 Comments   
Comment by Asya Kamsky [ 15/May/17 ]

This feature depends on being able to send different commands in the same batch, tracked by SERVER-2172.

Comment by Nick Judson [ 08/Sep/15 ]

@Ramon Fernandez - Yes - thank you.

Comment by Ramon Fernandez Marina [ 08/Sep/15 ]

nick@innsenroute.com, if I understand your request correctly I think this ticket is a duplicate of SERVER-2172, so I'm going to mark this ticket as such.

Regards,
Ramón.

Generated at Thu Feb 08 03:53:31 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.