dolt icon indicating copy to clipboard operation
dolt copied to clipboard
verified publisher icon dolthub

Fast path for `IN` filter bump

Open jycor opened this issue 1 month ago • 19 comments

jycor avatar Nov 26 '25 23:11 jycor

#benchmark

jycor avatar Nov 26 '25 23:11 jycor

@jycor workflow run: https://github.com/dolthub/dolt/actions/runs/19720603828

github-actions[bot] avatar Nov 26 '25 23:11 github-actions[bot]

@jycor DOLT

comparing_percentages
100.000000 to 100.000000
version result total
2cbf8c4 ok 5937471
version total_tests
2cbf8c4 5937471
correctness_percentage
100.0

coffeegoddd avatar Nov 27 '25 00:11 coffeegoddd

@jycor DOLT

test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 64.47 64.47 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 91eda61d502e5397e9131f8fc7b28b38e87e2bf5 36.19 dolt 2cbf8c41b9a20f547db543d9e97037b4ae3b88fd 36.08 -0.3

coffeegoddd avatar Nov 27 '25 00:11 coffeegoddd

@jycor DOLT

read_tests from_latency to_latency percent_change
covering_index_scan 0.55 0.55 0.0
groupby_scan 13.22 13.46 1.82
index_join 2.11 2.11 0.0
index_join_scan 1.37 1.37 0.0
index_scan 24.38 25.28 3.69
oltp_point_select 0.28 0.28 0.0
oltp_read_only 5.37 5.28 -1.68
select_random_points 0.58 0.56 -3.45
select_random_ranges 0.57 0.57 0.0
table_scan 28.16 27.17 -3.52
types_table_scan 80.03 84.47 5.55
write_tests from_latency to_latency percent_change
oltp_delete_insert 6.55 6.55 0.0
oltp_insert 3.25 3.19 -1.85
oltp_read_write 11.65 11.65 0.0
oltp_update_index 3.3 3.25 -1.52
oltp_update_non_index 3.19 3.19 0.0
oltp_write_only 6.32 6.32 0.0
types_delete_insert 6.91 6.91 0.0

coffeegoddd avatar Nov 27 '25 01:11 coffeegoddd

#benchmark

jycor avatar Dec 05 '25 00:12 jycor

@jycor workflow run: https://github.com/dolthub/dolt/actions/runs/19948309612

github-actions[bot] avatar Dec 05 '25 00:12 github-actions[bot]

@jycor DOLT

comparing_percentages
100.000000 to 99.999949
version result total
6e7915a not ok 3
6e7915a ok 5937468
version total_tests
6e7915a 5937471
correctness_percentage
99.999949

coffeegoddd avatar Dec 05 '25 00:12 coffeegoddd

@jycor DOLT

test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 63.32 64.47 1.82
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 f73ec2d0e99eba062a6943b3264882e8e76cd369 36.71 dolt 6e7915afae080d59c5a834c33365a5dd5e0e6441 35.97 -2.02

coffeegoddd avatar Dec 05 '25 00:12 coffeegoddd

@jycor DOLT

read_tests from_latency to_latency percent_change
covering_index_scan 0.55 0.55 0.0
groupby_scan 11.65 11.65 0.0
index_join 1.96 1.96 0.0
index_join_scan 1.34 1.34 0.0
index_scan 22.69 22.69 0.0
oltp_point_select 0.27 0.28 3.7
oltp_read_only 5.28 5.28 0.0
select_random_points 0.58 0.55 -5.17
select_random_ranges 0.57 0.57 0.0
table_scan 27.66 28.16 1.81
types_table_scan 65.65 66.84 1.81
write_tests from_latency to_latency percent_change
oltp_delete_insert 6.55 6.55 0.0
oltp_insert 3.19 3.19 0.0
oltp_read_write 11.65 11.65 0.0
oltp_update_index 3.25 3.25 0.0
oltp_update_non_index 3.19 3.19 0.0
oltp_write_only 6.32 6.32 0.0
types_delete_insert 6.91 6.91 0.0

coffeegoddd avatar Dec 05 '25 01:12 coffeegoddd

@jycor DOLT

comparing_percentages
100.000000 to 100.000000
version result total
4487558 ok 5937471
version total_tests
4487558 5937471
correctness_percentage
100.0

coffeegoddd avatar Dec 05 '25 20:12 coffeegoddd

#benchmark

jycor avatar Dec 05 '25 20:12 jycor

@jycor workflow run: https://github.com/dolthub/dolt/actions/runs/19975547810

github-actions[bot] avatar Dec 05 '25 20:12 github-actions[bot]

@jycor DOLT

test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 63.32 63.32 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 f5562654c92de7211b251c66f394bfa20f38ed24 36.6 dolt 45d4c9b4e37463193c2d16292da185852a69be44 37.07 1.28

coffeegoddd avatar Dec 05 '25 21:12 coffeegoddd

@jycor DOLT

read_tests from_latency to_latency percent_change
covering_index_scan 0.55 0.55 0.0
groupby_scan 11.87 11.65 -1.85
index_join 1.96 1.96 0.0
index_join_scan 1.34 1.34 0.0
index_scan 22.69 22.69 0.0
oltp_point_select 0.28 0.28 0.0
oltp_read_only 5.28 5.28 0.0
select_random_points 0.58 0.55 -5.17
select_random_ranges 0.57 0.57 0.0
table_scan 28.16 27.66 -1.78
types_table_scan 65.65 65.65 0.0
write_tests from_latency to_latency percent_change
oltp_delete_insert 6.43 6.55 1.87
oltp_insert 3.19 3.19 0.0
oltp_read_write 11.65 11.65 0.0
oltp_update_index 3.25 3.25 0.0
oltp_update_non_index 3.19 3.19 0.0
oltp_write_only 6.32 6.32 0.0
types_delete_insert 6.91 6.91 0.0

coffeegoddd avatar Dec 05 '25 22:12 coffeegoddd

#benchmark

jycor avatar Dec 10 '25 23:12 jycor

@jycor workflow run: https://github.com/dolthub/dolt/actions/runs/20117006319

github-actions[bot] avatar Dec 10 '25 23:12 github-actions[bot]

@jycor DOLT

test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 63.32 63.32 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 0873caea36409c4779346debb1fd6bb011aa717f 36.51 dolt 7587503ef656e55b4e61ee4d5a6cd36e2268a2e4 36.51 0.0

coffeegoddd avatar Dec 11 '25 00:12 coffeegoddd

@jycor DOLT

read_tests from_latency to_latency percent_change
covering_index_scan 0.55 0.55 0.0
groupby_scan 12.08 12.3 1.82
index_join 1.96 2.0 2.04
index_join_scan 1.34 1.34 0.0
index_scan 22.69 22.69 0.0
oltp_point_select 0.28 0.28 0.0
oltp_read_only 5.28 5.28 0.0
select_random_points 0.58 0.58 0.0
select_random_ranges 0.57 0.57 0.0
table_scan 27.66 27.66 0.0
types_table_scan 66.84 66.84 0.0
write_tests from_latency to_latency percent_change
oltp_delete_insert 6.55 6.55 0.0
oltp_insert 3.19 3.19 0.0
oltp_read_write 11.65 11.65 0.0
oltp_update_index 3.25 3.25 0.0
oltp_update_non_index 3.19 3.19 0.0
oltp_write_only 6.32 6.32 0.0
types_delete_insert 6.91 6.91 0.0

coffeegoddd avatar Dec 11 '25 01:12 coffeegoddd

#benchmark

jycor avatar Dec 11 '25 10:12 jycor

@jycor workflow run: https://github.com/dolthub/dolt/actions/runs/20129998641

github-actions[bot] avatar Dec 11 '25 10:12 github-actions[bot]

@jycor DOLT

comparing_percentages
100.000000 to 100.000000
version result total
56d1a0a ok 5937471
version total_tests
56d1a0a 5937471
correctness_percentage
100.0

coffeegoddd avatar Dec 11 '25 10:12 coffeegoddd

@jycor DOLT

test_name from_latency_p95 to_latency_p95 percent_change
tpcc-scale-factor-1 63.32 63.32 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 8db3a9c253cfaf90bd73c5d39eaedce3259479c7 36.68 dolt 56d1a0a1fc5b9d06e5e023dd1931c8ce7f63f410 36.51 -0.46

coffeegoddd avatar Dec 11 '25 11:12 coffeegoddd

@coffeegoddd DOLT

comparing_percentages
100.000000 to 100.000000
version result total
7e5b014 ok 5937471
version total_tests
7e5b014 5937471
correctness_percentage
100.0

coffeegoddd avatar Dec 11 '25 11:12 coffeegoddd

@jycor DOLT

read_tests from_latency to_latency percent_change
covering_index_scan 0.55 0.55 0.0
groupby_scan 11.87 11.87 0.0
index_join 1.96 1.96 0.0
index_join_scan 1.34 1.34 0.0
index_scan 22.28 22.69 1.84
oltp_point_select 0.28 0.27 -3.57
oltp_read_only 5.28 5.28 0.0
select_random_points 0.58 0.55 -5.17
select_random_ranges 0.57 0.57 0.0
table_scan 27.66 28.16 1.81
types_table_scan 66.84 65.65 -1.78
write_tests from_latency to_latency percent_change
oltp_delete_insert 6.55 6.55 0.0
oltp_insert 3.19 3.19 0.0
oltp_read_write 11.65 11.65 0.0
oltp_update_index 3.25 3.25 0.0
oltp_update_non_index 3.19 3.19 0.0
oltp_write_only 6.32 6.32 0.0
types_delete_insert 6.91 6.91 0.0

coffeegoddd avatar Dec 11 '25 11:12 coffeegoddd