In [1]:
import warnings
warnings.filterwarnings('ignore')
from benchmarkit import (BenchEnv,
BenchmarkIt,
print_banner)
db_name = 'nbmz_8_100000_1.db'
plot = True
plot_opt = 'all'
benv = BenchEnv(db_name=db_name)
bench_name = benv.bench_list[0]
corr = True
bench = BenchmarkIt.load(env=benv,
name=bench_name)
cases = bench.case_names
for case in cases:
print_banner("Case: {}".format(case))
df = bench.to_df(case=case, corrected=corr)
print(df)
if plot:
bench.plot(cases=cases,
corrected=corr,
plot_opt=plot_opt)
=========================
Case: P10sZarrCorrector
=========================
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 1365.957031 0.80 0.00 0.80
1 0 2 1365.957031 1.46 0.01 1.45
2 0 3 1366.316406 2.35 0.03 2.32
3 0 4 1382.925781 2.91 0.03 2.87
4 0 5 1402.261719 3.73 0.02 3.70
5 0 6 1412.460938 4.78 0.04 4.74
6 0 7 1424.023438 5.90 0.06 5.84
7 0 8 1434.664062 6.72 0.05 6.66
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.68 1.09 0.88
1 1.63 1.09 0.88
2 1.58 1.09 0.89
3 1.49 1.08 0.89
4 1.49 1.10 0.89
5 1.38 1.09 0.90
6 1.27 1.08 0.90
7 1.33 1.11 0.91
=======================
Case: P10sH5Corrector
=======================
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 1369.246094 0.20 0.01 0.18
1 0 2 1399.242188 0.36 0.03 0.31
2 0 3 1424.953125 0.51 0.06 0.46
3 0 4 1434.875000 0.67 0.09 0.56
4 0 5 1473.582031 0.80 0.09 0.70
5 0 6 1539.894531 1.00 0.15 0.84
6 0 7 1538.093750 1.15 0.16 0.97
7 0 8 1554.687500 1.20 0.15 1.04
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.45 0.90 0.81
1 1.45 0.90 0.81
2 1.57 0.93 0.82
3 1.57 0.93 0.82
4 1.53 0.94 0.82
5 1.53 0.94 0.82
6 1.57 0.95 0.83
7 1.52 0.95 0.83
====================
Case: P10sNPMinMax
====================
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 0.382812 0.40 0.00 0.20
1 0 2 -24.777344 0.58 0.00 0.38
2 0 3 0.441406 0.70 0.01 0.49
3 0 4 1.355469 0.79 0.00 0.59
4 0 5 -1.160156 1.11 0.02 0.90
5 0 6 30.128906 1.29 0.02 1.06
6 0 7 17.699219 1.54 -0.01 1.34
7 0 8 -2.871094 1.63 0.02 1.41
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.00 0.76 0.76
1 1.00 0.76 0.76
2 1.00 0.76 0.76
3 1.08 0.78 0.77
4 1.15 0.81 0.78
5 1.22 0.83 0.78
6 1.44 0.88 0.80
7 1.49 0.90 0.81
======================
Case: P10sZarrMinMax
======================
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 0.382812 1.66 0.01 1.43
1 0 2 0.406250 3.20 0.03 2.97
2 0 3 0.875000 4.27 0.02 4.05
3 0 4 1.082031 5.81 0.01 5.61
4 0 5 -0.363281 7.15 0.03 6.93
5 0 6 1.554688 9.12 0.24 8.69
6 0 7 0.949219 9.83 -0.04 9.66
7 0 8 0.867188 10.18 0.00 9.99
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.52 1.17 0.94
1 1.51 1.18 0.95
2 1.40 1.17 0.95
3 1.32 1.17 0.95
4 1.32 1.18 0.97
5 1.28 1.19 0.98
6 1.37 1.23 1.01
7 1.32 1.24 1.02
====================
Case: P10sH5MinMax
====================
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 0.382812 0.59 0.00 0.40
1 0 2 3.640625 0.90 0.03 0.68
2 0 3 4.851562 1.23 0.00 1.02
3 0 4 36.078125 1.41 0.01 1.21
4 0 5 42.765625 1.92 0.02 1.70
5 0 6 -7.136719 2.37 0.00 2.17
6 0 7 2.375000 2.62 -0.02 2.45
7 0 8 2.246094 2.76 -0.02 2.58
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.52 0.95 0.83
1 1.40 0.94 0.82
2 1.29 0.92 0.82
3 1.26 0.92 0.82
4 1.45 0.98 0.84
5 1.57 1.01 0.85
6 1.53 1.03 0.86
7 1.52 1.04 0.87
==============
Case: Pandas
==============
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 1363.351562 0.02 0.00 0.01
1 0 2 1363.351562 0.04 0.00 0.03
2 0 3 1363.351562 0.05 0.01 0.03
3 0 4 1363.351562 0.07 0.01 0.05
4 0 5 1401.300781 0.76 0.68 0.07
5 0 6 1406.199219 1.15 1.06 0.09
6 0 7 1416.507812 1.37 1.27 0.10
7 0 8 1421.406250 1.56 1.44 0.12
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.36 1.27 1.04
1 1.36 1.27 1.04
2 1.36 1.27 1.04
3 1.36 1.27 1.04
4 1.33 1.27 1.04
5 1.33 1.27 1.04
6 1.31 1.26 1.04
7 1.28 1.26 1.04
=======================
Case: P10sNPCorrector
=======================
Measure X100000 rows Memory usage Elapsed time System time User time \
0 0 1 1365.527344 0.07 0.01 0.06
1 0 2 1390.687500 0.13 0.01 0.11
2 0 3 1394.042969 0.20 0.02 0.17
3 0 4 1405.312500 0.28 0.05 0.22
4 0 5 1421.589844 0.33 0.04 0.28
5 0 6 1447.597656 0.41 0.08 0.32
6 0 7 1460.156250 0.43 0.08 0.35
7 0 8 1474.175781 0.48 0.06 0.41
Load avg.(-1s) Load avg.(-5s) Load avg.(-15s)
0 1.0 0.75 0.76
1 1.0 0.75 0.76
2 1.0 0.75 0.76
3 1.0 0.75 0.76
4 1.0 0.75 0.76
5 1.0 0.75 0.76
6 1.0 0.76 0.76
7 1.0 0.76 0.76
In [ ]:
Content source: jdfekete/progressivis
Similar notebooks: