[SERVER-33788] db.createView to allow UNION of multiple collections Created: 09/Mar/18 Updated: 02/Apr/18 Resolved: 09/Mar/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Aggregation Framework |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Mike Hsu | Assignee: | Kelsey Schubert |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | read-only-views | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Description |
|
Would like to implement "partitioned collection" with a view of multiple collections. For example, a rolling 12 monthly collections UNIONed to a view. rebuild the view every month to include the new moth and drop the oldest collection. This will avoid the slow performance of deleting one month of data with could be over 300 million documents. |
| Comments |
| Comment by Kelsey Schubert [ 09/Mar/18 ] |
|
Hi mhsuqcom, Thanks for the feature request. As Kyle mentions, Kind regards, |
| Comment by Kyle Suarez [ 09/Mar/18 ] |
|
This could be accomplished with |