[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: |
|
||||||||||||
| 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, |