[SERVER-65482] Optimize bulk inserts on collections with column index Created: 12/Apr/22 Updated: 06/Dec/22 Resolved: 26/May/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Ian Boros | Assignee: | Backlog - Query Execution |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Execution
|
||||||||
| Participants: | |||||||||
| Description |
|
When doing a bulk insert into a collection with a column index, we should also bulk insert keys into the column index itself. This can be done by generating all of the keys for the documents inserted, and inserting all of the keys for path 'a' together, then all of the keys for path 'b' together, etc etc. To do this, we should change the column key generator so that it can generate keys for multiple documents, and then visit all of the keys for one path, then the next, and so on. |