0e31f1f8b60b61b70093a50ef3b064fd637c68c9

CSV - column_set() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on indexed

rows=200000

*mean*	36.614
σ	0.000
min	36.614
max	36.615

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	12.661
σ	0.363
min	11.993
max	13.285

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.613
max	36.614

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	12.743
σ	0.581
min	12.008
max	13.728

CSV - column_set() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense, repeat

rows=200000

*mean*	62.074
σ	0.000
min	62.074
max	62.074

*mean*	5218.000
σ	2576.846
min	1266.000
max	8618.000

*mean*	104.593
σ	11.780
min	84.835
max	116.346

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	137.496
σ	5.460
min	125.971
max	143.595

CSV - column_set(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=column_set() on unindexed, dense

rows=200000

*mean*	15109.672
σ	3.988
min	15108.410
max	15121.021

*mean*	5218.000
σ	2576.846
min	1266.000
max	8618.000

*mean*	9660.113
σ	2164.029
min	6756.809
max	12585.732

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732
σ	0.001
min	14060.731
max	14060.735

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	7588.130
σ	1719.962
min	5505.124
max	9424.793

CSV - loading a lazy table

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=load_product() with indexes

rows=200000

*mean*	8744.667
σ	0.418
min	8744.534
max	8745.858

*mean*	4843.900
σ	2511.079
min	1044.000
max	8618.000

*mean*	4498.070
σ	1243.308
min	3516.577
max	7292.244

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	1270.322
σ	485.121
min	1039.422
max	2437.312

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	14.368
σ	1.354
min	11.057
max	15.594

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.904

*mean*	8736.900
σ	375.995
min	8618.000
max	9807.000

*mean*	12.839
σ	1.804
min	10.913
max	16.035

CSV - table_records(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records()

rows=200000

*mean*	15088.238
σ	0.002
min	15088.237
max	15088.241

*mean*	8736.900
σ	375.995
min	8618.000
max	9807.000

*mean*	9379.752
σ	2135.065
min	6660.524
max	12497.695

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.397
σ	0.000
min	26.397
max	26.398

*mean*	5218.000
σ	2576.846
min	1266.000
max	8618.000

*mean*	7.311
σ	0.321
min	6.882
max	7.871

CSV - vertical_lookup_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int

rows=200000

*mean*	40.944
σ	0.002
min	40.942
max	40.947

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	203.890
σ	329.196
min	84.207
max	1140.603

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.943
σ	0.002
min	40.942
max	40.946

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	97.414
σ	9.911
min	76.758
max	105.489

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end, repeat

rows=200000

*mean*	40.948
σ	0.002
min	40.947
max	40.951

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	100.670
σ	7.239
min	84.472
max	108.020

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	27.602
σ	0.002
min	27.602
max	27.607

*mean*	5218.000
σ	2576.846
min	1266.000
max	8618.000

*mean*	9.602
σ	0.670
min	8.710
max	10.251

iterations=10

operation_display=vertical_lookup_list() on unindexed unique Int near end

rows=200000

*mean*	40.949
σ	0.002
min	40.947
max	40.952

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	100.818
σ	7.394
min	84.103
max	107.951

CSV - vertical_lookup_list(), warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed

rows=200000

*mean*	15073.940
σ	0.000
min	15073.939
max	15073.940

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	9618.040
σ	2127.473
min	6595.672
max	12503.876

CSV - vertical_lookup_row_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed

rows=200000

*mean*	25.633
σ	0.002
min	25.631
max	25.637

*mean*	8736.900
σ	375.995
min	8618.000
max	9807.000

*mean*	5.781
σ	0.829
min	5.381
max	8.125

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628
σ	0.002
min	25.626
max	25.631

*mean*	8736.900
σ	375.995
min	8618.000
max	9807.000

*mean*	5.541
σ	0.378
min	5.275
max	6.567

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.002
min	25.930
max	25.935

*mean*	8736.900
σ	375.995
min	8618.000
max	9807.000

*mean*	5.560
σ	0.410
min	5.294
max	6.654

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat

rows=200000

*mean*	25.931
σ	0.002
min	25.930
max	25.934

*mean*	8736.900
σ	375.995
min	8618.000
max	9807.000

*mean*	5.516
σ	0.377
min	5.309
max	6.576

CSV - vertical_lookup_row_list() on unindexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int

rows=200000

*mean*	66.671
σ	0.001
min	66.670
max	66.673

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	150.013
σ	17.158
min	109.815
max	164.003

iterations=10

operation_display=vertical_lookup_row_list() on unindexed small unique Int, repeat

rows=200000

*mean*	66.670
σ	0.002
min	66.670
max	66.673

*mean*	9807.000
σ	0.000
min	9807.000
max	9807.000

*mean*	151.012
σ	17.178
min	110.861
max	165.391

CSV internal benchmark: pointedIndexFromKvs

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=pointedIndexFromKvs

rows=200000

*mean*	172.559
σ	0.002
min	172.558
max	172.562

*mean*	477.000
σ	0.000
min	477.000
max	477.000

*mean*	389.841
σ	19.486
min	359.578
max	405.835

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	560.100
σ	0.316
min	560.000
max	561.000

*mean*	758.484
σ	40.642
min	682.059
max	826.925