Closed fulghum closed 6 days ago
@coffeegoddd DOLT | test_name | detail | row_cnt | sorted | mysql_time | sql_mult | cli_mult |
---|---|---|---|---|---|---|---|
batching | LOAD DATA | 10000 | 1 | 0.06 | 1.5 | ||
batching | batch sql | 10000 | 1 | 0.07 | 2 | ||
batching | by line sql | 10000 | 1 | 0.07 | 2 | ||
blob | 1 blob | 200000 | 1 | 0.87 | 4.06 | 4.03 | |
blob | 2 blobs | 200000 | 1 | 0.86 | 4.56 | 4.52 | |
blob | no blob | 200000 | 1 | 0.85 | 2.6 | 2.18 | |
col type | datetime | 200000 | 1 | 0.8 | 3.06 | 2.89 | |
col type | varchar | 200000 | 1 | 0.65 | 3.65 | 3.03 | |
config width | 2 cols | 200000 | 1 | 0.77 | 2.61 | 2.18 | |
config width | 32 cols | 200000 | 1 | 1.78 | 2.1 | 2.57 | |
config width | 8 cols | 200000 | 1 | 0.95 | 2.43 | 2.26 | |
pk type | float | 200000 | 1 | 0.89 | 2.27 | 1.92 | |
pk type | int | 200000 | 1 | 0.75 | 2.69 | 2.24 | |
pk type | varchar | 200000 | 1 | 1.47 | 1.79 | 1.46 | |
row count | 1.6mm | 1600000 | 1 | 5.46 | 3.05 | 2.58 | |
row count | 400k | 400000 | 1 | 1.41 | 2.91 | 2.42 | |
row count | 800k | 800000 | 1 | 2.81 | 2.96 | 2.46 | |
secondary index | four index | 200000 | 1 | 3.47 | 1.4 | 1.1 | |
secondary index | no secondary | 200000 | 1 | 0.89 | 2.53 | 2.09 | |
secondary index | one index | 200000 | 1 | 1.11 | 2.46 | 2.12 | |
secondary index | two index | 200000 | 1 | 1.92 | 1.81 | 1.46 | |
sorting | shuffled 1mm | 1000000 | 0 | 4.92 | 2.95 | 2.64 | |
sorting | sorted 1mm | 1000000 | 1 | 5 | 2.92 | 2.61 |
@coffeegoddd DOLT | name | detail | mean_mult |
---|---|---|---|
dolt_blame_basic | system table | 1.23 | |
dolt_blame_commit_filter | system table | 3.37 | |
dolt_commit_ancestors_commit_filter | system table | 0.84 | |
dolt_commits_commit_filter | system table | 0.97 | |
dolt_diff_log_join_from_commit | system table | 2.03 | |
dolt_diff_log_join_to_commit | system table | 2.04 | |
dolt_diff_table_from_commit_filter | system table | 1.08 | |
dolt_diff_table_to_commit_filter | system table | 1.1 | |
dolt_diffs_commit_filter | system table | 0.92 | |
dolt_history_commit_filter | system table | 1.14 | |
dolt_log_commit_filter | system table | 0.94 |
@coffeegoddd DOLT | name | add_cnt | delete_cnt | update_cnt | latency |
---|---|---|---|---|---|
adds_only | 60000 | 0 | 0 | 1.36 | |
adds_updates_deletes | 60000 | 60000 | 60000 | 4.43 | |
deletes_only | 0 | 60000 | 0 | 2.42 | |
updates_only | 0 | 0 | 60000 | 3 |
This BATS test doesn't seem to run well in Lambda BATS. It failed for me four times in a row today, and I saw it failing a bunch last week, too. Disabling it in Lambda BATS.