[SERVER-27698] Materialized Views Created: 16/Jan/17 Updated: 06/Dec/22 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | Usability |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | John Crenshaw | Assignee: | Backlog - Query Execution |
| Resolution: | Unresolved | Votes: | 28 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||||||
| Participants: | |||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||
| Description |
| Comments |
| Comment by Daniel Pasette (Inactive) [ 18/Aug/20 ] |
|
marcelnsquaredsoftware@gmail.com, I wonder if using a pattern of "on-demand materialized views" (which leverages the $merge functionality released in v4.2) would apply to your use case. |
| Comment by Marcel Kroll [ 18/Aug/20 ] |
|
+1 to this. Not being able to do an SQL equivalent materialised view makes dealing with datasets spanning millions of records a real issue especially when we are dealing with down stream clients having to wait for complex aggregate queries to complete on large data sets (or even hit HTTP timeouts due to the query taking too long). In cases where 100% accuracy isn't required being able to instantly query even old data would be preferable if the result returned near instantaneously.
M.
|
| Comment by Ravi N [ 21/Dec/18 ] |
|
Thank you. Ravi Kumar Nagireddygari Be carbon conscious. Please consider our environment before printing this email. |
| Comment by Ramon Fernandez Marina [ 20/Dec/18 ] |
|
ravi.kumar.nagireddy@morganstanley.com, this feature is in our backlog but unfortunately there's no concrete timeline for it at the moment. We'll post updates to this ticket as that changes in the future. Thanks, |
| Comment by Ravi N [ 12/Dec/18 ] |
|
Is there a timeline when this feature would be available? |
| Comment by Mark Agarunov [ 17/Jan/17 ] |
|
Hi bugslayer, Thank you for the detailed example. I've set the fixVersion to "Needs Triage" for this new feature to be scheduled against our currently planned work. Updates will be posted on this ticket as they happen. Thanks, |