GitHub Actions run
CPU Simulation
5 hours ago aaa042a gsarmaonline:gsarma/issue-5781 pull_requestThis run is associated to a commit that was force-pushed
It will not be associated with its branch history. Be careful when comparing its performance to other runs.Compare
Base
Search a run
Head
CompareCase sensitive table, schema and view creation
#5949
gsarmaonline:gsarma/issue-5781
5 hours ago
CPU Simulation
384 total
sqlite_parse_query[SELECT 1]
core/benches/benchmark.rs::benches::bench_prepare_query::Prepare `SELECT 1`23.9 µs
sqlite_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes11.2 ms
limbo_mvcc_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes96.8 ms
limbo_wal_concurrent_writes
core/benches/benchmark.rs::benches::bench_concurrent_writes::Concurrent writes38.8 ms
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`418.8 µs
sqlite_execute_select_1
core/benches/benchmark.rs::benches::bench_execute_select_1::Execute `SELECT 1`4.4 µs
relaxed_budget[1000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_and_probe::HashTable Build+Probe640.6 µs
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`167.8 µs
sqlite_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`166.7 µs
limbo_execute_select_1
core/benches/benchmark.rs::benches::bench_execute_select_1::Execute `SELECT 1`11 µs
sqlite_execute_select_count
core/benches/benchmark.rs::benches::bench_execute_select_count::Execute `SELECT count() FROM users`20.1 µs
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`69.1 µs
integer_keys[1000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_relaxed_budget::HashTable Build (Relaxed Budget)317.1 µs
integer_keys[10000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_relaxed_budget::HashTable Build (Relaxed Budget)3.1 ms
limbo_execute_select_rows[10]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`51.8 µs
relaxed_budget[5000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_and_probe::HashTable Build+Probe4 ms
limbo_execute_select_rows[100]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`232.4 µs
sqlite_execute_select_rows[100]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`90.7 µs
limbo_execute_select_count
core/benches/benchmark.rs::benches::bench_execute_select_count::Execute `SELECT count() FROM users`131.3 µs
limbo_execute_select_rows[1]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`32 µs
with_100b_payload[10000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_relaxed_budget::HashTable Build (Relaxed Budget)8 ms
tight_budget[1000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_and_probe::HashTable Build+Probe641.2 µs
integer_keys[5000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_relaxed_budget::HashTable Build (Relaxed Budget)1.6 ms
limbo_execute_select_rows[50]
core/benches/benchmark.rs::benches::bench_execute_select_rows::Execute `SELECT * FROM users LIMIT ?`132.5 µs
integer_keys[10000]
core/benches/hash_spill_benchmark.rs::benches::bench_build_tight_budget::HashTable Build (Tight Budget)4 ms