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

Initial compound query support

#153Merged

Comparing

131-more-slts--iv

(

81d4c37

) with

main

(

22176cc

)

-22%

Improvements: 1

Regressions: 2

Untouched: 70

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_no_matches[1000000]

criterion::hash_join_no_matches::1000000

Regression

-17%

214.2 ms258 ms

ingest_mixed_1M[batches=16]

criterion::ingest_mixed_1M::batches=16

Regression

-22%

347 ms444.8 ms

Improved

hash_join_inner_join[1000000]

criterion::hash_join_inner_join::1000000

+37%

285.1 ms208.5 ms

Passed

storage_sequential_both_case_sensitive

criterion::string_substring_storage_only

+9%

54.9 ms50.3 ms

highfrag/range/with_index

criterion::index_matrix_1M::highfrag_range_with_index

+7%

3.4 ms3.2 ms

storage_sequential_contains_case_insensitive

criterion::string_substring_storage_only

+7%

116.2 ms108.5 ms

storage_sequential_starts_case_insensitive

criterion::string_substring_storage_only

+7%

94.9 ms89.1 ms

storage_fused_contains_case_insensitive

criterion::string_substring_storage_only

+6%

89.7 ms84.6 ms

hash_join_inner_join[10000]

criterion::hash_join_inner_join::10000

+5%

672 µs638.8 µs

hash_join_anti_join[1000000]

criterion::hash_join_anti_join::1000000

+5%

53.5 ms51 ms

hash_join_semi_join[1000000]

criterion::hash_join_semi_join::1000000

+4%

46.8 ms44.8 ms

storage_fused_both_case_insensitive

criterion::string_substring_storage_only

+4%

88.8 ms85.2 ms

table_layer_sum

criterion::table_layer_overhead_analysis

+3%

107.2 µs103.6 µs

scan_unsorted_multiset

criterion::random_probe_u64

+3%

1.6 ms1.5 ms

planner_fused_both_case_sensitive

criterion::string_substring_fused_vs_sequential

+3%

20.3 ms19.8 ms

direct_columnstore_sum

criterion::table_layer_overhead_analysis

+3%

103.1 µs100.4 µs

hash_join_left_join[1000000]

criterion::hash_join_left_join::1000000

+3%

159 ms155 ms

highfrag/range/without_index

criterion::index_matrix_1M::highfrag_range_without_index

+2%

5.7 ms5.5 ms

scan_stream_sum_u64

criterion::llkv_table_math_1M

+2%

106.4 µs104.2 µs

lowfrag/range/with_index

criterion::index_matrix_1M::lowfrag_range_with_index

+2%

2 ms2 ms

ingest_mixed_1M[batches=1]

criterion::ingest_mixed_1M::batches=1

+1%

212 ms209.1 ms

hash_join_no_matches[100000]

criterion::hash_join_no_matches::100000

+1%

11.5 ms11.3 ms

sum_u64_fragmented_scan_only

criterion::column_store_fragmented_1M

+1%

89.2 µs88.3 µs

unsorted_sum_u64

criterion::scan_builder_1M

+1%

940.4 µs931.6 µs

store_sequential_both_case_insensitive

criterion::string_substring_fused_vs_sequential

+1%

144.9 ms143.9 ms

hash_join_many_to_many[10000]

criterion::hash_join_many_to_many::10000

+1%

838.7 µs833.3 µs

hash_join_left_join[100000]

criterion::hash_join_left_join::100000

+1%

8.4 ms8.4 ms

storage_fused_both_case_sensitive

criterion::string_substring_storage_only

4.9 ms4.9 ms

highfrag/full/with_index

criterion::index_matrix_1M::highfrag_full_with_index

46.1 ms45.9 ms

sum_i32_scan_only

criterion::column_store_sum_1M

48.7 µs48.5 µs

hash_join_left_join[10000]

criterion::hash_join_left_join::10000

612.7 µs610.7 µs

hash_join_anti_join[100000]

criterion::hash_join_anti_join::100000

4.2 ms4.2 ms

lowfrag/full/without_index

criterion::index_matrix_1M::lowfrag_full_without_index

14.5 ms14.5 ms

lowfrag/full/with_index

criterion::index_matrix_1M::lowfrag_full_with_index

22.6 ms22.5 ms

scan_stream_expr_add_one

criterion::llkv_table_math_1M

984.6 µs983.2 µs

storage_fused_starts_case_insensitive

criterion::string_substring_storage_only

4.9 ms4.9 ms

storage_sequential_both_case_insensitive

criterion::string_substring_storage_only

143.7 ms143.6 ms

single_column

criterion::gather_rows

620.4 µs620.8 µs

scan_sorted_stream_join

criterion::random_probe_u64

22.2 ms22.3 ms

hash_join_semi_join[100000]

criterion::hash_join_semi_join::100000

3.6 ms3.6 ms

sorted_with_row_ids_u64

criterion::scan_builder_1M

21.1 ms21.1 ms

multi_column_batched_with_nulls

criterion::gather_rows

649.1 µs650.1 µs

multi_column_sequential

criterion::gather_rows

1.9 ms1.9 ms

hash_join_left_join[1000]

criterion::hash_join_left_join::1000

150.9 µs151.2 µs

multi_column_batched

criterion::gather_rows

1.8 ms1.8 ms

planner_fused_both_case_insensitive

criterion::string_substring_fused_vs_sequential

102.9 ms103.2 ms

hash_join_inner_join[100000]

criterion::hash_join_inner_join::100000

12.3 ms12.3 ms

scan_contains_needle_case_insensitive

criterion::string_substring_search

103 ms103.4 ms

scan_stream_expr_divide_two

criterion::llkv_table_math_1M

-1%

1 ms1 ms

lowfrag/range/without_index

criterion::index_matrix_1M::lowfrag_range_without_index

-1%

3.8 ms3.8 ms

sum_u64_scan_only

criterion::column_store_sum_1M

-1%

100.5 µs101 µs

scan_stream_expr_subtract_one

criterion::llkv_table_math_1M

-1%

1 ms1 ms

hash_join_many_to_many[100000]

criterion::hash_join_many_to_many::100000

-1%

13.6 ms13.7 ms

hash_join_semi_join[10000]

criterion::hash_join_semi_join::10000

-1%

243.4 µs245.5 µs

scan_stream_expr_multiply_two

criterion::llkv_table_math_1M

-1%

1 ms1 ms

hash_join_anti_join[1000]

criterion::hash_join_anti_join::1000

-1%

85.5 µs86.5 µs

planner_fused_starts_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

19.5 ms19.8 ms

sorted_range_u64

criterion::scan_builder_1M

-1%

23.1 ms23.4 ms

store_sequential_contains_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

105.4 ms106.9 ms

store_sequential_starts_case_insensitive

criterion::string_substring_fused_vs_sequential

-1%

87.3 ms88.5 ms

highfrag/full/without_index

criterion::index_matrix_1M::highfrag_full_without_index

-1%

14.2 ms14.4 ms

hash_join_semi_join[1000]

criterion::hash_join_semi_join::1000

-1%

80.4 µs81.6 µs

planner_fused_contains_case_insensitive

criterion::string_substring_fused_vs_sequential

-2%

101.7 ms103.4 ms

hash_join_no_matches[10000]

criterion::hash_join_no_matches::10000

-2%

642.8 µs657.7 µs

store_sequential_both_case_sensitive

criterion::string_substring_fused_vs_sequential

-3%

48.4 ms50.1 ms

hash_join_many_to_many[100]

criterion::hash_join_many_to_many::100

-3%

76.4 µs79.2 µs

hash_join_anti_join[10000]

criterion::hash_join_anti_join::10000

-3%

279 µs289 µs

scan_contains_needle_case_sensitive

criterion::string_substring_search

-4%

45.3 ms47.2 ms

ingest_mixed_1M[batches=64]

criterion::ingest_mixed_1M::batches=64

-4%

762.6 ms797.4 ms

hash_join_inner_join[1000]

criterion::hash_join_inner_join::1000

-5%

89.6 µs94.1 µs

hash_join_many_to_many[1000]

criterion::hash_join_many_to_many::1000

-6%

167.1 µs178.3 µs

hash_join_no_matches[1000]

criterion::hash_join_no_matches::1000

-7%

149.8 µs160.8 µs

ingest_mixed_1M[batches=4]

criterion::ingest_mixed_1M::batches=4

-8%

277.8 ms301.7 ms

Commits

Click on a commit to change the comparison range

Base

main

22176cc

-21.98%

`cargo fmt`

81d4c37

3 days ago

by jzombie

Home Terms Privacy Docs