dolthub / dolt

Dolt – Git for Data
https://www.dolthub.com
Apache License 2.0
18k stars 516 forks source link

Sql row interface #8547

Open max-hoffman opened 2 weeks ago

max-hoffman commented 2 weeks ago

benchmark

github-actions[bot] commented 2 weeks ago

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

max-hoffman commented 2 weeks ago

benchmark

github-actions[bot] commented 2 weeks ago

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

coffeegoddd commented 2 weeks ago
@max-hoffman DOLT test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 61.08 61.08 0.0
test_name from_server_name from_server_version from_tps to_server_name to_server_version to_tps percent_change
tpcc-scale-factor-1 dolt 884cb4dfd05ddb1f64f02fb4ce787cc63e1059fa 40.9 dolt 50ba42a5e955f26a33c7a40d561fb04472e48e33 40.79 -0.27
coffeegoddd commented 2 weeks ago
@max-hoffman DOLT read_tests from_latency to_latency percent_change
covering_index_scan 0.61 0.62 1.64
groupby_scan 16.41 17.32 5.55
index_join 2.26 2.39 5.75
index_join_scan 1.82 2.52 38.46
index_scan 54.83 56.84 3.67
oltp_point_select 0.26 0.27 3.85
oltp_read_only 5.37 5.57 3.72
select_random_points 0.65 0.67 3.08
select_random_ranges 0.63 0.64 1.59
table_scan 55.82 56.84 1.83
types_table_scan 147.61 150.29 1.82
write_tests from_latency to_latency percent_change
oltp_delete_insert 5.88 5.88 0.0
oltp_insert 2.91 2.91 0.0
oltp_read_write 11.45 11.65 1.75
oltp_update_index 2.97 2.97 0.0
oltp_update_non_index 2.91 2.91 0.0
oltp_write_only 5.99 5.99 0.0
types_delete_insert 6.21 6.32 1.77
max-hoffman commented 2 weeks ago

benchmark

github-actions[bot] commented 2 weeks ago

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

coffeegoddd commented 2 weeks ago
@max-hoffman DOLT test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 58.92 58.92 0.0
test_name from_server_name from_server_version from_tps to_server_name to_server_version to_tps percent_change
tpcc-scale-factor-1 dolt c32bddd101a43e23b907a74a0aaef01330b84837 41.58 dolt 0810f7c8dbf7eae09eacfee833ef6cae033f0a53 40.51 -2.57
coffeegoddd commented 2 weeks ago
@max-hoffman DOLT read_tests from_latency to_latency percent_change
covering_index_scan 0.62 0.62 0.0
groupby_scan 16.71 17.01 1.8
index_join 2.26 2.35 3.98
index_join_scan 1.82 2.18 19.78
index_scan 54.83 55.82 1.81
oltp_point_select 0.27 0.26 -3.7
oltp_read_only 5.37 5.47 1.86
select_random_points 0.65 0.65 0.0
select_random_ranges 0.64 0.63 -1.56
table_scan 55.82 55.82 0.0
types_table_scan 150.29 144.97 -3.54
write_tests from_latency to_latency percent_change
oltp_delete_insert 5.77 5.88 1.91
oltp_insert 2.91 2.86 -1.72
oltp_read_write 11.45 11.24 -1.83
oltp_update_index 2.91 2.91 0.0
oltp_update_non_index 2.91 2.86 -1.72
oltp_write_only 5.88 5.88 0.0
types_delete_insert 6.21 6.21 0.0
max-hoffman commented 1 week ago

benchmark

github-actions[bot] commented 1 week ago

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

max-hoffman commented 1 week ago

benchmark

github-actions[bot] commented 1 week ago

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

coffeegoddd commented 1 week ago
@max-hoffman DOLT test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 61.08 61.08 0.0
test_name from_server_name from_server_version from_tps to_server_name to_server_version to_tps percent_change
tpcc-scale-factor-1 dolt 38a1da463ec429685625d5787723e657b7e2b23d 40.64 dolt 65d5075bc70538603c636334392580bbe8f65ec2 40.17 -1.16
coffeegoddd commented 1 week ago
@max-hoffman DOLT read_tests from_latency to_latency percent_change
covering_index_scan 0.63 0.63 0.0
groupby_scan 16.71 17.63 5.51
index_join 2.3 2.39 3.91
index_join_scan 1.82 1.52 -16.48
index_scan 57.87 57.87 0.0
oltp_point_select 0.27 0.27 0.0
oltp_read_only 5.47 5.57 1.83
select_random_points 0.67 0.67 0.0
select_random_ranges 0.64 0.65 1.56
table_scan 58.92 57.87 -1.78
types_table_scan 153.02 150.29 -1.78
write_tests from_latency to_latency percent_change
oltp_delete_insert 5.88 5.88 0.0
oltp_insert 2.91 2.91 0.0
oltp_read_write 11.45 11.65 1.75
oltp_update_index 2.97 2.97 0.0
oltp_update_non_index 2.91 2.91 0.0
oltp_write_only 5.99 5.99 0.0
types_delete_insert 6.32 6.32 0.0
coffeegoddd commented 2 days ago

@max-hoffman DOLT

comparing_percentages
100.000000 to 100.000000
version result total
ba4b835 ok 5937457
version total_tests
ba4b835 5937457
correctness_percentage
100.0