-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
ALL
-
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Discovered while analyzing why q1, q2, and q3 have high coefficient of variance in this multi-patch comparison: https://performance-analyzer.server-tig.prod.corp.mongodb.com/perf-analyzer-viz?comparison_id=6881164078014293c88e9752&selected_tab=data-table&measurement_filter=AverageLatency&percent_filter=0%7C%7C100&z_filter=0%7C%7C10&filter_type=Default
It turns out that these queries have high coefficient of variance because they are the first queries to run. There is something slows down the first 60-100 queries that run, and this something seems to decay exponentially.
I have attached two graphs. The first one runs one query 100 times and tracks its runtime over time. The second one runs 9 different queries 13 times each and tracks the runtime over time.