sim: verify table contents after REOPEN_DATABASE fault
#6559Comparing
benzaid32:sim-verify-reopen-database
(bf858ef
) withmain
(8671c12
)0%
- Untouched
- 323
- Skipped
- 105
Benchmarks
428 total
begin_tx-read-commit_tx
core/benches/mvcc_benchmark.rs::benches::bench::mvcc-ops-throughput+2%
17.9 µs17.5 µs
upper_long_string
core/benches/sql_functions/value.rs::value+1%
2.8 µs2.8 µs
sqlite_analyzed[3_aggregate_or_in]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `3_aggregate_or_in`0%
205.7 µs205.1 µs
Sqlite3
core/benches/json_benchmark.rs::benches::bench::JSONB Size - Real world json 30%
23.1 µs23 µs
update
core/benches/mvcc_benchmark.rs::benches::bench::mvcc-ops-throughput0%
14.6 µs14.5 µs
limbo_execute_select_rows[1]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`0%
33.3 µs33.2 µs
sqlite_schema[]
core/benches/benchmark.rs::benches::bench_open::Open/Connect0%
52.1 ms52 ms
modifier_localtime
core/benches/sql_functions/datetime.rs::datetime0%
23.3 µs23.3 µs
flat[]
core/benches/struct_union_benchmark.rs::grp_insert::bench_insert::insert0%
141.4 µs141.2 µs
limbo_parser_query[]
parser/benches/parser_benchmark.rs::benches::bench_parser::Parser `SELECT * FROM users LIMIT 1`0%
17.2 µs17.2 µs
limbo_schema[]
core/benches/benchmark.rs::benches::bench_open::Open/Connect0%
63.6 ms63.5 ms
limbo_execute_select_rows[10]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`0%
57.1 µs57 µs
limbo[3_aggregate_or_in]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `3_aggregate_or_in`0%
650.6 µs650 µs
sqlite_analyzed[d_inlist_union]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `d_inlist_union`0%
420.7 µs420.3 µs
limbo[batch_update]
core/benches/write_perf_benchmark.rs::write_perf_benches::bench_update_performance::UPDATE Performance0%
44.3 µs44.3 µs
sqlite[d_inlist_union]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `d_inlist_union`0%
421.8 µs421.5 µs
limbo_parse_query[SELECT first_name, last_name, state, city, age + 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT first_name, last_name, state, city, age + 10, LENGTH(email), UPPER(first_name), LOWER(last_name), SUBSTR(phone_number, 1, 3), zipcode || '-' || state, AVG(age) + 5, MAX(age) - MIN(age), ROUND(AVG(age), 1), SUM(age) / COUNT(*), COUNT(*), COUNT(email), SUM(age), AVG(age), MIN(age), MAX(age), SUM(CASE WHEN age >= 18 THEN 1 ELSE 0 END), SUM(CASE WHEN age < 18 THEN 1 ELSE 0 END), AVG(CASE WHEN age >= 18 THEN age ELSE NULL END), MAX(CASE WHEN age >= 18 THEN age ELSE NULL END) FROM users GROUP BY state, city`0%
458.8 µs458.5 µs
sqlite_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes0%
11.2 ms11.2 ms
sqlite_parse_query[SELECT first_name, count(1) FROM users GROUP BY fi]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT first_name, count(1) FROM users GROUP BY first_name HAVING count(1) > 1 ORDER BY count(1) LIMIT 1`0%
69.3 µs69.3 µs
sqlite[3_aggregate_or_in]
core/benches/graph_queries_benchmark.rs::benches::bench_graph_queries::GraphQuery `3_aggregate_or_in`0%
1.5 ms1.5 ms
with_100b_payload[5000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_relaxed_budget::HashTable Build (Relaxed Budget)0%
4.4 ms4.4 ms
limbo_parse_query[SELECT first_name, count(1) FROM users GROUP BY fi]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT first_name, count(1) FROM users GROUP BY first_name HAVING count(1) > 1 ORDER BY count(1) LIMIT 1`0%
174.3 µs174.2 µs
limbo_parse_query[SELECT 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT 1`0%
60.3 µs60.3 µs
Limbo
core/benches/json_benchmark.rs::benches::bench_json_patch::JSON Patch - Array Update0%
31.1 µs31 µs
limbo_mvcc_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes0%
107 ms106.9 ms
Commits
Click on a commit to change the comparison rangeBase
main
8671c12
-0.01%
sim: verify table contents after REOPEN_DATABASE fault
bf858ef
2 days ago
by benzaid32