search

crate / crate-benchmarks

A collection of CrateDB benchmarks.
8 stars 4 forks source link

Add benchmarks for simple subquery #103

Closed mfussenegger closed 7 years ago

mfussenegger commented 7 years ago

This requires functionality that is in the simple-subquery branch in the crate project, so don't merge yet.

First query:

Runtime (in ms):
    mean:    24.132 ± 0.181
    min/max: 9.362 → 70.624
Percentile:
    50:   24.887 ± 4.129 (stdev)
    95:   27.873
    99.9: 63.995

Second query: (this should get a lot faster once we add the fetch-propagation optimization)

Runtime (in ms):
    mean:    1287.632 ± 25.463
    min/max: 1137.688 → 1486.777
Percentile:
    50:   1290.236 ± 91.861 (stdev)
    95:   1434.237
    99.9: 1486.777