benchmarks-nl-distribution

                |  All rows match (Cart product) | 4/5 of rows filtered out
----------------+--------------------------------+-------------------------
concurrency = 1 |                                |
================+================================+=========================
Distributed     |                       2192.042 |              3634.034                       
----------------+--------------------------------+-------------------------
Non-distributed |                       1896.855 |             14893.225
---------------------------------------------------------------------------


concurrency = 15|                                |
================+================================+=========================
Distributed     |                       5308.429 |              8647.100                        
----------------+--------------------------------+-------------------------
Non-distributed |                       5171.366 |             40718.666
----------------+--------------------------------+-------------------------





@@@@@@@@@@@@@@@@@@@@@@
@@   Distributed NL @@
@@@@@@@@@@@@@@@@@@@@@@
# Running setUp
2 requests [00:01,  1.06s/ requests]
2 requests [00:01,  1.19 requests/s]
# Running benchmark

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 li
   Concurrency: 1
   Iterations: 200
100%|██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 200/200 [08:04<00:00,  2.45s/ requests]
Runtime (in ms):
    mean:    2192.042 ± 14.198
    min/max: 1986.455 → 3037.710
Percentile:
    50:   2184.484 ± 102.446 (stdev)
    95:   2328.072
    99.9: 3037.710

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 an
   Concurrency: 1
   Iterations: 200
100%|██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 200/200 [13:16<00:00,  3.85s/ requests]
Runtime (in ms):
    mean:    3634.034 ± 12.858
    min/max: 3444.035 → 4149.597
Percentile:
    50:   3623.804 ± 92.777 (stdev)
    95:   3810.739
    99.9: 4149.597
# Running tearDown

with concurrency:
# Running setUp
2 requests [00:01,  1.39s/ requests]
2 requests [00:01,  1.20 requests/s]
# Running benchmark

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 li
   Concurrency: 15
   Iterations: 200
100%|██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 200/200 [01:18<00:00,  3.21 requests/s]
Runtime (in ms):
    mean:    5308.429 ± 78.237
    min/max: 3240.926 → 6581.706
Percentile:
    50:   5368.823 ± 564.507 (stdev)
    95:   6121.716
    99.9: 6581.706

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 an
   Concurrency: 15
   Iterations: 200
100%|██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 200/200 [02:07<00:00,  1.57 requests/s]
Runtime (in ms):
    mean:    8647.100 ± 119.286
    min/max: 4521.520 → 10404.252
Percentile:
    50:   8760.125 ± 860.692 (stdev)
    95:   9770.506
    99.9: 10404.252
# Running tearDown



@@@@@@@@@@@@@@@@@@@@@@@@@
@@  Non-Distributed NL @@
@@@@@@@@@@@@@@@@@@@@@@@@@
# Running setUp
2 requests [00:00,  2.29 requests/s]
2 requests [00:00,  3.09 requests/s]
# Running benchmark

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 li
   Concurrency: 1
   Iterations: 200
100%|██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 200/200 [07:10<00:00,  2.10s/ requests]
Runtime (in ms):
    mean:    1896.855 ± 13.846
    min/max: 1710.559 → 2273.311
Percentile:
    50:   1897.419 ± 99.901 (stdev)
    95:   2054.038
    99.9: 2273.311
    
    
# Running setUp
2 requests [00:01,  1.22 requests/s]
2 requests [00:00,  2.60 requests/s]
# Running benchmark

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 an
   Concurrency: 1
   Iterations: 50
100%|████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 50/50 [12:36<00:00, 15.11s/ requests]
Runtime (in ms):
    mean:    14893.225 ± 68.687
    min/max: 14557.410 → 16081.162
Percentile:
    50:   14864.991 ± 247.800 (stdev)
    95:   15335.877
    99.9: 16081.162
# Running tearDown

with concurrency:
# Running setUp
2 requests [00:00,  1.31 requests/s]
2 requests [00:00,  2.81 requests/s]
# Running benchmark

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 li
   Concurrency: 15
   Iterations: 200
100%|██████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 200/200 [01:13<00:00,  2.72 requests/s]
Runtime (in ms):
    mean:    5171.366 ± 62.376
    min/max: 2671.363 → 6022.876
Percentile:
    50:   5222.878 ± 450.066 (stdev)
    95:   5684.084
    99.9: 6022.876

## Running Query:
   Statement: select t1.id1, t2.id1 from matriv.t1, matriv.t2 where t1.id1=t2.id1 an
   Concurrency: 15
   Iterations: 50
100%|████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████| 50/50 [02:31<00:00,  3.02s/ requests]
Runtime (in ms):
    mean:    40718.666 ± 1911.630
    min/max: 19196.703 → 45703.152
Percentile:
    50:   42917.844 ± 6896.565 (stdev)
    95:   45423.312
    99.9: 45703.152
# Running tearDown