c98f63bdc3a29193a4e53760df8bfbf483c314ff

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.614

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	13.058
σ	0.432
min	12.147
max	13.508

iterations=10

operation_display=column_set() on indexed, repeat

rows=200000

*mean*	36.614
σ	0.000
min	36.613
max	36.614

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	12.894
σ	0.707
min	12.008
max	13.885

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.075

*mean*	5246.900
σ	2600.715
min	1267.000
max	8687.000

*mean*	134.251
σ	96.083
min	78.390
max	405.367

iterations=10

operation_display=column_set() on unindexed, sparse, repeat

rows=200000

*mean*	70.664
σ	0.002
min	70.662
max	70.667

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	134.909
σ	5.573
min	119.865
max	138.220

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*	5136.500
σ	2457.972
min	1267.000
max	8687.000

*mean*	9406.381
σ	2054.681
min	6639.596
max	11602.380

iterations=10

operation_display=column_set() on unindexed, sparse

rows=200000

*mean*	14060.732
σ	0.002
min	14060.731
max	14060.735

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	6560.638
σ	1343.440
min	5414.853
max	8330.570

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.535
σ	0.000
min	8744.534
max	8744.535

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	4576.251
σ	1196.705
min	3508.740
max	6703.248

iterations=10

operation_display=load_product(), no indexes

rows=200000

*mean*	2524.581
σ	0.002
min	2524.579
max	2524.583

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	1391.591
σ	766.119
min	1023.785
max	3103.937

iterations=10

operation_display=load_product(), with indexes

rows=200000

*mean*	8744.667
σ	0.419
min	8744.534
max	8745.858

*mean*	4869.500
σ	2532.683
min	1044.000
max	8687.000

*mean*	4269.021
σ	850.485
min	3499.055
max	6052.779

iterations=10

operation_display=load_product()with indexes

rows=200000

*mean*	8744.532
σ	0.002
min	8744.530
max	8744.534

*mean*	8687.000
σ	0.000
min	8687.000
max	8687.000

*mean*	4321.495
σ	1357.399
min	3499.259
max	7071.214

CSV - table_records()

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=table_records(), no indexes

rows=200000

*mean*	41.902
σ	0.002
min	41.899
max	41.904

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	14.181
σ	1.133
min	11.947
max	15.573

iterations=10

operation_display=table_records(), no indexes, repeat

rows=200000

*mean*	41.901
σ	0.001
min	41.900
max	41.903

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	13.289
σ	1.342
min	11.089
max	15.486

iterations=10

operation_display=table_records(), repeat

rows=200000

*mean*	41.901
σ	0.002
min	41.899
max	41.903

*mean*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	13.206
σ	2.053
min	11.074
max	16.889

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*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	9301.587
σ	2078.843
min	6528.243
max	11883.670

CSV - vertical_lookup_list() on indexed

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set(), repeat

rows=200000

*mean*	26.397
σ	0.000
min	26.397
max	26.398

*mean*	5246.900
σ	2600.715
min	1267.000
max	8687.000

*mean*	6.869
σ	0.359
min	6.417
max	7.411

iterations=10

operation_display=vertical_lookup_list() on indexed, after table_records(), repeat

rows=200000

*mean*	26.398
σ	0.002
min	26.397
max	26.401

*mean*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	6.827
σ	0.762
min	5.641
max	8.629

iterations=10

operation_display=vertical_lookup_list() on indexed, repeat

rows=200000

*mean*	26.398
σ	0.000
min	26.398
max	26.398

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	8.003
σ	0.421
min	7.184
max	8.566

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*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	171.954
σ	227.124
min	73.088
max	817.473

iterations=10

operation_display=vertical_lookup_list() on unindexed missing Int, repeat

rows=200000

*mean*	40.944
σ	0.002
min	40.942
max	40.946

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	194.503
σ	303.208
min	73.036
max	1056.753

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.953

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	100.711
σ	11.773
min	73.853
max	108.701

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*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	100.647
σ	11.885
min	73.187
max	108.306

CSV - vertical_lookup_list(), mini warmup

Factor

allocated MiB

peak allocated MiB

time (ms)

iterations=10

operation_display=vertical_lookup_list() on indexed, after column_set()

rows=200000

*mean*	27.602
σ	0.002
min	27.602
max	27.607

*mean*	5246.900
σ	2600.715
min	1267.000
max	8687.000

*mean*	9.697
σ	0.655
min	8.810
max	10.558

iterations=10

operation_display=vertical_lookup_list() on indexed, after table_records()

rows=200000

*mean*	27.602
σ	0.001
min	27.602
max	27.605

*mean*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	9.260
σ	0.840
min	8.367
max	11.234

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.001
min	15073.939
max	15073.943

*mean*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	10163.300
σ	2086.693
min	6505.978
max	12224.303

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*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	5.268
σ	0.548
min	4.729
max	6.745

iterations=10

operation_display=vertical_lookup_row_list() on 2 indexed, repeat

rows=200000

*mean*	25.628
σ	0.003
min	25.626
max	25.634

*mean*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	5.232
σ	0.557
min	4.757
max	6.745

iterations=10

operation_display=vertical_lookup_row_list() on 3 (1 unindexed)

rows=200000

*mean*	25.932
σ	0.003
min	25.930
max	25.939

*mean*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	5.333
σ	0.622
min	4.903
max	7.053

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*	8776.200
σ	282.075
min	8687.000
max	9579.000

*mean*	5.356
σ	0.584
min	4.949
max	6.930

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*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	147.826
σ	17.963
min	118.335
max	164.315

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*	9579.000
σ	0.000
min	9579.000
max	9579.000

*mean*	145.470
σ	20.902
min	116.467
max	165.513

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*	393.947
σ	5.598
min	383.424
max	399.320

iterations=10

operation_display=pointedIndexFromKvs

rows=400000

*mean*	357.322
σ	0.002
min	357.321
max	357.325

*mean*	558.900
σ	1.197
min	558.000
max	561.000

*mean*	743.172
σ	44.231
min	643.340
max	781.224