-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
The idea is to measure performance of the following query:
{$group: {_id:"ticker", m: {$min: {price}}}}
in two scenarios:
- against a TS collection. All the data will be unpacked before grouping.
- against the corresponding bucket collection. Buckets will not be unpacked at all and min will be calculated based on mins stored in buckets. This requires rewriting this query to an equivalent version working with buckets.
The point of the experiment is to give us an idea of the performance boost, as we can extrapolate what the boost would be if a portion of buckets needs to be unpacked, e.g. due to a filter on time. We expect orders of magnitude.
At the moment we believe that queries that conceptually do not need to unpack a portion of buckets are common. We can confirm that using telemetry in the future.