131-more-slts--ii - Branch - jzombie/rust-llkv

Add correlated subqueries: new exprs, centralized correlation, planner/executor support

#151Merged

Comparing

131-more-slts--ii

(

229250c

) with

main

(

4c369a2

)

-29%

Improvements: 8

Regressions: 5

Untouched: 60

Unknown Walltime execution environment detected

Using the Walltime instrument on standard Hosted Runners will lead to inconsistent data. For the most accurate results, we recommend using CodSpeed Macro Runners: bare-metal machines fine-tuned for performance measurement consistency.

Benchmarks

Failed

hash_join_anti_join[1000]

criterion::hash_join_anti_join::1000

Regression

-22%

66.4 µs85.6 µs

scan_contains_needle_case_sensitive

criterion::string_substring_search

Regression

-12%

40.4 ms45.9 ms

hash_join_inner_join[1000000]

criterion::hash_join_inner_join::1000000

Regression

-25%

212.7 ms285.4 ms

hash_join_no_matches[1000000]

criterion::hash_join_no_matches::1000000

Regression

-29%

186.1 ms260.6 ms

unsorted_sum_u64

criterion::scan_builder_1M

Regression

-21%

772.3 µs981.9 µs

Improved

ingest_mixed_1M[batches=64]

criterion::ingest_mixed_1M::batches=64

+19%

940.4 ms787.8 ms

hash_join_inner_join[100000]

criterion::hash_join_inner_join::100000

+16%

14.5 ms12.5 ms

ingest_mixed_1M[batches=4]

criterion::ingest_mixed_1M::batches=4

+16%

315.6 ms273 ms

hash_join_many_to_many[10000]

criterion::hash_join_many_to_many::10000

+16%

963.8 µs833.7 µs

hash_join_no_matches[100000]

criterion::hash_join_no_matches::100000

+11%

12.8 ms11.5 ms

scan_unsorted_multiset

criterion::random_probe_u64

+11%

1.8 ms1.6 ms

ingest_mixed_1M[batches=16]

criterion::ingest_mixed_1M::batches=16

+10%

451.3 ms409.5 ms

hash_join_left_join[100000]

criterion::hash_join_left_join::100000

+10%

9.2 ms8.4 ms

Passed

scan_sorted_stream_join

criterion::random_probe_u64

+5%

23.6 ms22.4 ms

highfrag/range/with_index

criterion::index_matrix_1M::highfrag_range_with_index

+5%

3.4 ms3.2 ms

hash_join_many_to_many[1000]

criterion::hash_join_many_to_many::1000

+5%

187 µs178.8 µs

hash_join_many_to_many[100000]

criterion::hash_join_many_to_many::100000

+4%

14.3 ms13.8 ms

hash_join_semi_join[100000]

criterion::hash_join_semi_join::100000

+4%

3.8 ms3.6 ms

lowfrag/full/with_index

criterion::index_matrix_1M::lowfrag_full_with_index

+4%

23.3 ms22.4 ms

hash_join_no_matches[1000]

criterion::hash_join_no_matches::1000

+3%

165.7 µs160.1 µs

hash_join_no_matches[10000]

criterion::hash_join_no_matches::10000

+3%

701.3 µs679.9 µs

hash_join_many_to_many[100]

criterion::hash_join_many_to_many::100

+3%

89.4 µs86.8 µs

sum_u64_scan_only

criterion::column_store_sum_1M

+3%

101.2 µs98.2 µs

storage_fused_both_case_sensitive

criterion::string_substring_storage_only

+3%

5.1 ms5 ms

scan_stream_expr_multiply_two

criterion::llkv_table_math_1M

+2%

1 ms1 ms

scan_stream_expr_subtract_one

criterion::llkv_table_math_1M

+2%

1 ms1 ms

storage_fused_starts_case_insensitive

criterion::string_substring_storage_only

+2%

5.1 ms5 ms

scan_stream_sum_u64

criterion::llkv_table_math_1M

+1%

107.9 µs106.4 µs

highfrag/full/with_index

criterion::index_matrix_1M::highfrag_full_with_index

+1%

46.6 ms46.1 ms

storage_fused_both_case_insensitive

criterion::string_substring_storage_only

+1%

85.4 ms84.4 ms

hash_join_anti_join[100000]

criterion::hash_join_anti_join::100000

+1%

4.3 ms4.2 ms

sum_u64_fragmented_scan_only

criterion::column_store_fragmented_1M

+1%

92.4 µs91.5 µs

hash_join_semi_join[1000]

criterion::hash_join_semi_join::1000

+1%

81.8 µs81 µs

sum_i32_scan_only

criterion::column_store_sum_1M

+1%

49 µs48.5 µs

single_column

criterion::gather_rows

+1%

625.7 µs621.1 µs

highfrag/full/without_index

criterion::index_matrix_1M::highfrag_full_without_index

+1%

14.7 ms14.5 ms

lowfrag/full/without_index

criterion::index_matrix_1M::lowfrag_full_without_index

+1%

14.9 ms14.8 ms

lowfrag/range/with_index

criterion::index_matrix_1M::lowfrag_range_with_index

+1%

2.1 ms2.1 ms

hash_join_inner_join[10000]

criterion::hash_join_inner_join::10000

684.5 µs681.3 µs

multi_column_batched

criterion::gather_rows

1.9 ms1.8 ms

store_sequential_contains_case_insensitive

criterion::string_substring_fused_vs_sequential

108.1 ms107.6 ms

direct_columnstore_sum

criterion::table_layer_overhead_analysis

102.4 µs102.1 µs

planner_fused_both_case_sensitive

criterion::string_substring_fused_vs_sequential

19.8 ms19.7 ms

sorted_range_u64

criterion::scan_builder_1M

23.8 ms23.8 ms

storage_fused_contains_case_insensitive

criterion::string_substring_storage_only

84.7 ms84.8 ms

multi_column_sequential

criterion::gather_rows

1.9 ms1.9 ms

multi_column_batched_with_nulls

criterion::gather_rows

649 µs650.1 µs

storage_sequential_contains_case_insensitive

criterion::string_substring_storage_only

106 ms106.4 ms

hash_join_left_join[10000]

criterion::hash_join_left_join::10000

615.5 µs617.5 µs

store_sequential_both_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

143.7 ms144.5 ms

planner_fused_starts_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

19.9 ms20 ms

table_layer_sum

criterion::table_layer_overhead_analysis

-1%

104.5 µs105.3 µs

lowfrag/range/without_index

criterion::index_matrix_1M::lowfrag_range_without_index

-1%

3.7 ms3.8 ms

hash_join_anti_join[1000000]

criterion::hash_join_anti_join::1000000

-1%

50 ms50.6 ms

hash_join_inner_join[1000]

criterion::hash_join_inner_join::1000

-2%

92.5 µs94.4 µs

hash_join_semi_join[10000]

criterion::hash_join_semi_join::10000

-2%

249.1 µs254.3 µs

storage_sequential_both_case_insensitive

criterion::string_substring_storage_only

-2%

142 ms145.3 ms

highfrag/range/without_index

criterion::index_matrix_1M::highfrag_range_without_index

-2%

5.1 ms5.2 ms

scan_stream_expr_add_one

criterion::llkv_table_math_1M

-2%

987.1 µs1,011.6 µs

planner_fused_contains_case_insensitive

criterion::string_substring_fused_vs_sequential

-3%

99.7 ms102.3 ms

scan_contains_needle_case_insensitive

criterion::string_substring_search

-3%

98.6 ms101.4 ms

planner_fused_both_case_insensitive

criterion::string_substring_fused_vs_sequential

-3%

99.8 ms102.9 ms

sorted_with_row_ids_u64

criterion::scan_builder_1M

-4%

20.6 ms21.4 ms

scan_stream_expr_divide_two

criterion::llkv_table_math_1M

-4%

1 ms1.1 ms

hash_join_left_join[1000]

criterion::hash_join_left_join::1000

-4%

145.6 µs151.8 µs

hash_join_semi_join[1000000]

criterion::hash_join_semi_join::1000000

-4%

44 ms45.9 ms

storage_sequential_starts_case_insensitive

criterion::string_substring_storage_only

-4%

82.1 ms85.7 ms

store_sequential_starts_case_insensitive

criterion::string_substring_fused_vs_sequential

-4%

82.4 ms86.2 ms

storage_sequential_both_case_sensitive

criterion::string_substring_storage_only

-6%

46.1 ms48.9 ms

store_sequential_both_case_sensitive

criterion::string_substring_fused_vs_sequential

-7%

45.3 ms48.6 ms

ingest_mixed_1M[batches=1]

criterion::ingest_mixed_1M::batches=1

-8%

188.7 ms204.7 ms

hash_join_left_join[1000000]

criterion::hash_join_left_join::1000000

-9%

128.5 ms141.7 ms

hash_join_anti_join[10000]

criterion::hash_join_anti_join::10000

-10%

264.6 µs293.1 µs

Commits

Click on a commit to change the comparison range

Base

main

4c369a2

-28.59%

Resolve Clippy warnings

229250c

4 days ago

by jzombie

Home Terms Privacy Docs