[SERVER-84854] Triage queries sourced from internal systems for evaluating SBE perf Created: 13/Apr/20 Updated: 12/Jan/24 Resolved: 13/Apr/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | David Storch | Assignee: | Justin Seyster |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Sprint: | Query 2020-04-20 |
| Participants: |
| Comments |
| Comment by Justin Seyster [ 13/Apr/20 ] |
|
Here are my notes for the queries linked from these sources: The main conclusion is that there are few queries we could execute and benchmark from the compass-analytics-helpers.js file linked to in the "Product Analytics" wiki page. Most of these queries require features that our current SBE prototype does not support, but almost all of them are good candidates for benchmarking real-world scenarios once we are closer to a complete SBE implementation. In particular, many of these queries use the $group stage. If we wanted to extend the spike to get a more robust performance picture, we might consider implementing $group. Other common unsupported stages are $lookup, $unwind, and $facet. Driver stats (Natalya Furmanova) Distributed system analytics (Sheeri Cabral) Compass analytics (Massimiliano Marcon) Charts analytics (Tom Hollander) COVID-19 dashboard (by Thomas Rueckstiess) |