dolt icon indicating copy to clipboard operation
dolt copied to clipboard

insert perf bump

Open max-hoffman opened this issue 9 months ago • 17 comments

max-hoffman avatar May 09 '24 18:05 max-hoffman

#benchmark

max-hoffman avatar May 09 '24 18:05 max-hoffman

@max-hoffman workflow run: https://github.com/dolthub/dolt/actions/runs/9021604193

github-actions[bot] avatar May 09 '24 18:05 github-actions[bot]

@max-hoffman DOLT

comparing_percentages
100.000000 to 100.000000
version result total
978128b ok 5937457
version total_tests
978128b 5937457
correctness_percentage
100.0

coffeegoddd avatar May 09 '24 18:05 coffeegoddd

@max-hoffman DOLT

test_name from_latency_median to_latency_median is_faster
tpcc-scale-factor-1 97.55 97.55 0
test_name server_name server_version tps test_name server_name server_version tps is_faster
tpcc-scale-factor-1 dolt 12335605bc803f151fc5d85c612341b56549488b 22.54 tpcc-scale-factor-1 dolt 978128bac1cdc1defe2e6b58c17ecadc21be4e5f 22.66 0

coffeegoddd avatar May 09 '24 18:05 coffeegoddd

@max-hoffman DOLT

read_tests from_latency_median to_latency_median is_faster
covering_index_scan 2.97 2.97 0
groupby_scan 17.63 17.63 0
index_join 5.18 5.18 0
index_join_scan 2.22 2.26 0
index_scan 53.85 53.85 0
oltp_point_select 0.51 0.51 0
oltp_read_only 8.43 8.43 0
select_random_points 0.8 0.8 0
select_random_ranges 0.97 0.97 0
table_scan 53.85 54.83 0
types_table_scan 134.9 134.9 0
write_tests from_latency_median to_latency_median is_faster
oltp_delete_insert 6.91 6.91 0
oltp_insert 3.43 3.43 0
oltp_read_write 16.12 16.12 0
oltp_update_index 3.55 3.49 0
oltp_update_non_index 3.43 3.43 0
oltp_write_only 7.84 7.84 0
types_delete_insert 7.56 7.56 0

coffeegoddd avatar May 09 '24 19:05 coffeegoddd

#benchmark

max-hoffman avatar May 09 '24 20:05 max-hoffman

@max-hoffman workflow run: https://github.com/dolthub/dolt/actions/runs/9022901962

github-actions[bot] avatar May 09 '24 20:05 github-actions[bot]

@max-hoffman DOLT

comparing_percentages
100.000000 to 100.000000
version result total
50a2fa8 ok 5937457
version total_tests
50a2fa8 5937457
correctness_percentage
100.0

coffeegoddd avatar May 09 '24 20:05 coffeegoddd

@max-hoffman DOLT

test_name from_latency_median to_latency_median is_faster
tpcc-scale-factor-1 97.55 95.81 0
test_name server_name server_version tps test_name server_name server_version tps is_faster
tpcc-scale-factor-1 dolt 12335605bc803f151fc5d85c612341b56549488b 22.81 tpcc-scale-factor-1 dolt 50a2fa80a487d8698517df4cbda60b7209e8db5d 23.09 0

coffeegoddd avatar May 09 '24 20:05 coffeegoddd

@max-hoffman DOLT

read_tests from_latency_median to_latency_median is_faster
covering_index_scan 2.97 2.97 0
groupby_scan 17.63 17.63 0
index_join 5.09 5.09 0
index_join_scan 2.18 2.22 0
index_scan 52.89 52.89 0
oltp_point_select 0.5 0.51 0
oltp_read_only 8.43 8.43 0
select_random_points 0.8 0.8 0
select_random_ranges 0.95 0.95 0
table_scan 54.83 54.83 0
types_table_scan 137.35 134.9 0
write_tests from_latency_median to_latency_median is_faster
oltp_delete_insert 6.79 6.79 0
oltp_insert 3.43 3.36 0
oltp_read_write 16.12 16.12 0
oltp_update_index 3.49 3.49 0
oltp_update_non_index 3.43 3.43 0
oltp_write_only 7.84 7.84 0
types_delete_insert 7.56 7.56 0

coffeegoddd avatar May 09 '24 21:05 coffeegoddd

#benchmark

max-hoffman avatar May 09 '24 23:05 max-hoffman

@max-hoffman workflow run: https://github.com/dolthub/dolt/actions/runs/9024706154

github-actions[bot] avatar May 09 '24 23:05 github-actions[bot]

#benchmark

max-hoffman avatar May 09 '24 23:05 max-hoffman

@max-hoffman workflow run: https://github.com/dolthub/dolt/actions/runs/9024728893

github-actions[bot] avatar May 09 '24 23:05 github-actions[bot]

@max-hoffman DOLT

comparing_percentages
100.000000 to 100.000000
version result total
46e72b5 ok 5937457
version total_tests
46e72b5 5937457
correctness_percentage
100.0

coffeegoddd avatar May 09 '24 23:05 coffeegoddd

@max-hoffman DOLT

test_name from_latency_median to_latency_median is_faster
tpcc-scale-factor-1 97.55 95.81 0
test_name server_name server_version tps test_name server_name server_version tps is_faster
tpcc-scale-factor-1 dolt 12335605bc803f151fc5d85c612341b56549488b 22.63 tpcc-scale-factor-1 dolt 46e72b58e82c5007cce25c6954ad623565b96b5e 22.81 0

coffeegoddd avatar May 09 '24 23:05 coffeegoddd

@max-hoffman DOLT

read_tests from_latency_median to_latency_median is_faster
covering_index_scan 2.97 2.91 0
groupby_scan 17.63 17.32 0
index_join 5.18 5.09 0
index_join_scan 2.18 2.18 0
index_scan 52.89 51.94 0
oltp_point_select 0.51 0.49 0
oltp_read_only 8.43 8.13 0
select_random_points 0.8 0.78 0
select_random_ranges 0.95 0.94 0
table_scan 54.83 52.89 0
types_table_scan 137.35 132.49 0
write_tests from_latency_median to_latency_median is_faster
oltp_delete_insert 6.79 6.67 0
oltp_insert 3.43 3.25 0
oltp_read_write 16.12 15.55 0
oltp_update_index 3.49 3.49 0
oltp_update_non_index 3.43 3.43 0
oltp_write_only 7.84 7.43 0
types_delete_insert 7.56 7.43 0

coffeegoddd avatar May 10 '24 00:05 coffeegoddd