Skip to content

DoltLite 0.50.4

Choose a tag to compare

@timsehn timsehn released this 03 Sep 17:25
7f0a323

Go driver URI support and reliability fixes.

Go

  • Added URI filename support, including file:app.db?lazy_origin=1 for lazy clones.

Reliability

  • Hardened Homebrew release automation and the chunk-source integrity test.

Benchmark / int-keys (100K rows, Linux x64)

File-Backed

Reads

Test SQLite (us) DoltLite (us) Multiplier
oltp_point_select 42,644 26,503 0.62
oltp_range_select 11,902 10,434 0.88
oltp_sum_range 10,635 9,062 0.85
oltp_order_range 2,575 2,586 1.00
oltp_distinct_range 3,381 3,330 0.98
oltp_index_scan 5,899 4,546 0.77
select_random_points 11,448 10,050 0.88
select_random_ranges 5,387 3,919 0.73
covering_index_scan 5,883 3,735 0.63
groupby_scan 25,022 26,985 1.08
index_join 6,646 6,811 1.02
index_join_scan 2,824 3,797 1.34
types_table_scan 882,585 950,529 1.08
table_scan 1,006,968 1,059,392 1.05
oltp_read_only 121,478 104,051 0.86
Average 0.92

Writes

Test SQLite (us) DoltLite (us) Multiplier
oltp_bulk_insert 172,728 238,216 1.38
oltp_insert 25,860 36,816 1.42
oltp_update_index 140,286 128,634 0.92
oltp_update_non_index 133,176 91,659 0.69
oltp_delete_insert 155,658 99,526 0.64
oltp_write_only 130,995 88,232 0.67
types_delete_insert 227,835 182,608 0.80
oltp_read_write 126,488 119,340 0.94
Average 0.93

100000 rows, median of 5 paired invocations per test; autocommit writes use 9, workload-only timing via host monotonic clock when available.